Incorrect values within SQLDA Structure

[Jan Van Bogget]

Hello, this my big problem :

When i Insert data from memo1.text into my Firebird Table, i becomming the
following error :

Incorrect values within SQLDA Structure

This is the Delphi code that i use :


With SqlQuery1 do
begin
Sql.Clear;
Sql.Text := 'Insert Into Mijn_tabel(Omschrijving)
Values(:_Omschrijving);
ParamByName('_Omschrijving').AsBlob := Memo1.Text;
ExecSQL;
end;

I Work with D2007 Win32 with the lastest updates, Firebird 2.1 and
DbExpress ....


Wath is wrong ??
Thanks for Help ....

[srdaniel]

How is the BLOB field defined?
Could it be a character set issue?
Have you tried ParamByName('').asString instead of .asBlob?

Post by Jan Van Bogget
When i Insert data from memo1.text into my Firebird Table, i becomming
Incorrect values within SQLDA Structure
With SqlQuery1 do
begin
Sql.Clear;
Sql.Text := 'Insert Into Mijn_tabel(Omschrijving)
Values(:_Omschrijving);
ParamByName('_Omschrijving').AsBlob := Memo1.Text;
ExecSQL;
end;
I Work with D2007 Win32 with the lastest updates, Firebird 2.1 and
DbExpress ....
Wath is wrong ??
Thanks for Help ....

[Craig Stuntz [TeamB]]

Post by srdaniel
Have you tried ParamByName('').asString instead of .asBlob?

They are the same.

[Paul Hughes]

Post by Jan Van Bogget
When i Insert data from memo1.text into my Firebird Table, i becomming the
Incorrect values within SQLDA Structure

Also be aware that the CG supplied interbase driver may have some issues
with FB as it's not 'supported'. I would also check whether you have the
right fbclient.dll (copied to GDS32.dll) as I have seen that error myself
when using the interbase version of GDS32.dll.

There are some earlier posts on this subject too.

Regards, Paul.