Step 2 of the ' Create Table' second option from Manipulation


#1

Step 1. I added the table via: Create Table friends (id INTEGER, name TEXT, birthday DATE);

Step 2. Is to add a person: Insert Into friends (id, name, birthday) Values (1, 'Jane Doe', 1993-05-19);

Nothing happens.


#2

You'll need quotes on that date.


#3

... Of course, obvious now that you mention it. Thank you Albionsrefuge


#4

Well, maybe I should have tested before getting happy :smile: Problem persists after clicking the SAVE button the spinning icon just keeps on turning and turning and... I tried an easier version before posting my question, which was the same as in the training (age instead birthday) and had the same problem with the query not being saved. Just an infinite loop of the icon.

STEP 1. = Create table friends (id INTEGER, name TEXT, birthday DATE); (table pops after clicking the save button)
STEP 2. = Insert Into friends (id, name, birthday) Values (1, 'Jane Doe', '1993-05-19'); (infinite loop)


#5

Your INSERT command works for me. You didn't delete the CREATE TABLE command did you?


#6

A post was split to a new topic: Near line 2: near "intofriends": syntax error


#7