Subject Re: [IBO] Using parambyname('param').asstring stop the sequence.
Author William Hill
try this

Var Qry_prev:TIBoQuery;
Begin
Qry_Prev := TIBOQuery.Create(Self);

with Qry_Prev do
begin
IB_Connection := Connection;
SQL.add('Select * from mytable where C_login = :login');
Params.ParamByName('Login').asstring := '7';
open;
end;
end;

hth
William.

----- Original Message -----
From: "davissammybr" <davissammybr@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, September 07, 2002 7:42 PM
Subject: [IBO] Using parambyname('param').asstring stop the sequence.


> Hi,
> I'm using the folowing code:
>
> Var Qry_prev:TIBoQuery;
> Begin
> Qry_Prev := TIBOQuery.Create(Self);
> Qry_Prev.DatabaseName := Connection.Database;
>
> with Qry_Prev do
> begin
> Sql.Clear;
> SQL.add('Select * from mytable where C_login=:login');
> ParamByName('Login').asstring := '7';
> open;
> end;
> end;
>
> I'm debuging the code but the delphi stop in "parambyname" code
> line, and don't show any message error. Where is my error?
>
> Thanks.