Error message "Incorrect values within SQLDA structure" with Firebird and Delphi 2009

delphi delphi-2009 firebird dbx
Harriv picture Harriv · Dec 5, 2009 · Viewed 7.9k times · Source

I'm strugling with error message "Incorrect values within SQLDA structure" when I'm trying to update blob field within Firebird 2.1 database from Delphi 2009 DBX application.

However I get the error message when I'm trying to execute TSQLQuery with following SQL: "update MYTABLE set FIELD1= :data where id = :id"

The relevant delphi code is:

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

Where should I be looking? This has been working in earlier Delphi versions.

Answer

Erick Sasse picture Erick Sasse · Dec 7, 2009

This is the kind of crypt error that Delphi's Interbase driver is used to show.

I've seen this problem when you have different numbers of parameters in your SQL statement and the ones defined in your query component.

Related questions

Delphi 2006-2010 error: "Cannot create file C:\Users\Admin\AppData\Local\Temp\EditorLineEnds.ttr"

I am getting an error after installing Delphi 2007 (Edit: This problem occurs in all Delphi versions from 2006 to 2010) that I can not figure out and have never seen before. After restarting I can launch the program without any problems, but …

Read More
Converting TMemoryStream to 'String' in Delphi 2009

We had the following code prior to Delphi 2009: function MemoryStreamToString(M : TMemoryStream): String; var NewCapacity: Longint; begin if (M.Size = > 0) or (M.Memory = nil) then Result:= '' else begin if TMemoryStreamProtected(M).Capacity = M.Size then begin NewCapacity:= M.…

Read More
How to read data from xml file and display it over the text box in delphi language

I am new to the delphi language, and here I have a doubt, I have a xml file called vehicle.xml. It looks like this <data> <vehicle> <type>Car</type> <model&…

Read More