SQL Course Lesson 5

[vdeegan]

Could someone help me get past lesson 5 of the first SQLCourse.com? I keep
putting in what I feel are the right commands for inserting records, but
keep getting an error, for weeks now.
Here's the code I put:

insert into employee_jvd0515
(first, last, title, age, salary)
values('Jonie', 'Weber', 'Secretary', 28, 19500.00);

The table, with those fields, was successfully created previously.
Help. Thanks.
Vince Deegan

[sclark]

vdeegan, I just tried it, and it worked, but you must go through the procedures in order...first I created the table thusly:

create table myemployees_jvd0515(firstname varchar(30),
lastname varchar(30),
title varchar(30),
age number(2),
salary number(8,2));

then I inserted the data:

insert into myemployees_jvd0515
(firstname, lastname, title, age, salary)
values ('Jonie', 'Weber',
'Secretary', 28, 19500.00);

No problems at all. Try again using a different table name and you shouldn't have any problems.

[vdeegan]

I had been creating the table before doing any inserts. I tried it again exactly like you did it, but I'm still getting the same old error message. Don't know why it doesn't work when I do it and why it works when you do it. We're apparently doing the exact same thing. Again, here's my syntax:

create table
employee_vince0515
(first varchar(30),
last varchar(30),
title varchar(30),
age number(2),
salary number(8,2));

Then,

insert into
employee_vince0515
(first,last,title,age,salary)
values
('Jonie','Weber','Secretary',28,19500.00);

I tried it several ways:
1) Did the create in lesson 4 and the insert in lesson 5.
2) Did the create in the first query window of lesson 5 and the insert in the second query window of lesson 5.
3) Did the create followed by the insert as a separate statement, both in the first query window of lesson 5.

Nothing works. Help again. Thanks.

[sclark]

I'm stumped...I just tried it again, just cutting and pasting from the thread above. I created the table, then populated it, and didn't have any problems. Are you manually typing the text in, or cutting and pasting? You may need to change the table name...