Firebird Insert Query.
lazarus / 16-Databases

----------------------------------------------------------------------
cov · 2013-04-29 07:36

I'm trying to insert values into a table.

Code: [Select]    IBConnection1.ExecuteDirect('INSERT INTO
USERNAMES(ID,OPERATOR,STATUS) VALUES(0,"dave",2);');
    SQLTransaction1.Commit;                                          
 
But I'm getting an error:

QuoteIBConnection1 : PrepareStatement:
- Dynamic SQL Error
- SQL error code =-206
- Column unknown
- dave
- at line 1, column 47
A similar statement works without error elsewhereCode: [Select]

  IBConnection1.ExecuteDirect('INSERT INTO FIELDS(ID,"CLIENTNAME")
VALUES(68,''ASSMANG - NEWCASTLE-'')');
  SQLTransaction1.Commit;

----------------------------------------------------------------------
jujibo · 2013-04-29 07:50

The solution is in your second sql sentence.

Don't use " (double quote) for field values, use  two single quotes '
'

try:

IBConnection1.ExecuteDirect('INSERT INTO USERNAMES(ID,OPERATOR,STATUS)
VALUES(0,''dave'',2);');

----------------------------------------------------------------------
BigChimp · 2013-04-29 08:18

If you have these errors, copy/paste the SQL string into FlameRobin
and run it there.

jujibo is right: use ' for quoting strings... or parameterised queries
(see sqldbtutorial3).
Use " to quote table/object names (though not recommended as I think
then you need to match exact case)

----------------------------------------------------------------------
cov · 2013-04-29 14:47

Great, thanks very much, that's now working...