Insert Syntax Error - Solutions ???

zkold · Newbie Joined: 29 Mar 2006 Posts: 1

k , now i have already have a table for me to insert data,

but currently i wanna try to insert as syntax....

like maybe :

INSERT INTO aircraft VALUES ('123', '345', '456');

but there is an error prompting :

===The given command is not a SELECT statement.
Only queries are allowed

INSERT INTO aircraft VALUES ('123', '345', '456');===

current tat when i compile and execute the command but some how keep giving me this error prompt.

pls asap,need help here...thx

DrewJensen · Posted: Thu Mar 30, 2006 4:58 am Post subject:

I am thinking you are attempting to issue the command via a query builder window, witht he designer turned off. Won't work - you already know the error message you will get.

Open the SQL window insetad. Tools>SQL. The command will work just fine there also. With one change, you MUST double quote the table name - assuming this is an HSQL database. The SQL window will cast your command to all uppercase otherwise...and then fail with table not found.
_________________
Blog - http://baseanswers.spaces.live.com/