Hi, now its works but i don´t understand what occurs.
My project is a socket server (using Indy - Multhreads) and i have
only IBconnection to the project. I has been discovered what
disabling a timer in my project the code works fine. This timer have
one procedure to update using another Tiboquery, and this timer
execute it in 3 to 3 seconds for all clients sockets (~50 )connected.
I don´t have only two procedures like these in my project, i have
~20, but after connection the some clients ( ~4) the function and
procedures using Ibo stop locking the project. Before use interbase i
was using Advantage but it don´t has support to all updates and
selects. Then i has been changed to interbase. I has been changed all
querys and removed all advantage units of my projects and replace it
to IBO. It´s correct using IBO like i have describled ?

Thanks all.
Sammy Davis

--- In IBObjects@y..., "William Hill" <william@j...> wrote:
> 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@y...>
> To: <IBObjects@y...>
> 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.