Hi,
like it ?

Procedure Update_table;
Var Query:TIbo_query;
Session:TIb_session;
Begin

Session := Tib_session.create(nil);
Query := Tibo_query.create(session);


with query do
Begin
Sql.add('Update table set y=2 ');
execsql;
end

Query.free;
Session.free;

end;


Thanks.
Sammy Davis

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> When doing multi-threading in IBO it is appropriate to use an
explicit
> TIB_Session component for each thread module. Then, when creating
other IBO
> components, instead of using a nil owner, use the module's
TIB_Session
> component. If it is in a datamodule then just make sure the
TIB_Session
> component is first in the creation order.
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: "davissammybr" <davissammybr@y...>
> To: <IBObjects@y...>
> Sent: Monday, September 09, 2002 5:49 AM
> Subject: [IBO] Re: Using parambyname('param').asstring stop the
sequence.
>
>
> 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.