Error message "Invalid values ​​in SQLDA structure" with Firebird and Delphi 2009

Question

I am struggling with the "Incorrect Values ​​in SQLDA Structure" error message when I try to update the blob field in a Firebird 2.1 database from a DBX Delphi 2009 application.

However, I get an error when I try to execute TSQLQuery with the following SQL: "update MYTABLE set FIELD1 =: data where id =: id"

Relevant delphi code:

MyQuery.ParamByName('id').AsInteger := id;
MyQuery.ParamByName('data').LoadFromFile(filename, ftBlob);
MyQuery.ExecSQL();

Where should I look? This works in earlier versions of Delphi.

Answer 1

- Firebird Interbase. , Firebird SQLDA Blobs 2.1 , , Interbase .

:

• (, imho) Delphi 2010 - DBX Firebird (. )
• Firebird, Delphi 2009
• "" Firebird ( , ).
• . , .

Answer 2

, dbx firebird

http://sites.google.com/site/dbxfirebird/

Answer 3

, Delphi Interbase.

, SQL , .

Answer 4

, , - , dll (gds32.dll fb32.dll fbclient.dll, , Firebird ) , .

-

Answer 5

FWIW, I got this error in a perl program by executing an instruction without binding variables when needed.