insert into

[Karla]

I am inserting information into a table and the problem keeps saying I have an error. Where?
This is what I am writing -

Insert Into Employees
(firstname, lastname, title, age, salary)
values ('Jonie', 'Weber', 'secretary', 28, 19500.00);

[skhanal]

What is the exact error message?

Probably the data type and values you passed don't match.

[Karla]

The message I am receiving is:
Error occured.
Recheck your SQL statement.

Hopes this helps you in figuring out what I am doing wrong.
My table is
create table employees
(firstname varchar(15)
lastname varchar(20)
title varchar(20)
age number(3)
salary number(7,2));

[MAK]

your insert statement worked fine in ms-access and also in sql server.

what DB you are using?

[skhanal]

Is your database case sensitive?