BorlandTalk.com

GD · Guest

Hi,
I am using Firebird database with XTG ODBC driver, I have a 'big' problem
with parameter assignment of TADOQuery component uing the following simple
query under Delphi 7:

strSQL := 'select * from ASSOCIATE where LASTNAME = :LName';
ADOQrySelect.Active := False;
ADOQrySelect.SQL.Clear;
ADOQrySelect.SQL.Add(strSQL);
ADOQrySelect.Prepared := True;
ADOQrySelect.Parameters.ParamByName('Lname').DataType := ftString;
ADOQrySelect.Parameters.ParamByName('Lname').Direction := pdInput;
ADOQrySelect.Parameters.ParamByName('LName').Value := 'Bond';
ADOQrySelect.Active := True;

It raises OleException with message: "Parameter object was improperly
define" when the compiler is trying to run "ADOQrySelect.Active := True;".
However, if I use static SQL query string, it works fine.

Can someone please points out what is wrong?

TIA,

GD

Vitali Kalinin · Guest

Have you tried to assign Size for parameter?
Anyway AFAIK Firebird with ADO is not very promissing combination and ADO
with ODBC either.

Regards,
Vitali

GD · Guest

Yes, I set the size of 10.

Thanks for reply.

GD

"Vitali Kalinin" <vitkalinin (AT) yahoo (DOT) com> wrote