Firebird Insert Query.

[cov]

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:

IBConnection1 : PrepareStatement:
- Dynamic SQL Error
- SQL error code =-206
- Column unknown
- dave
- at line 1, column 47

A similar statement works without error elsewhere

Code: [Select]



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

[jujibo]

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]

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]

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