All except for there isn't a connection or transaction component.
Add those in there similar to how you did the query and it should be great.

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@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, September 09, 2002 4:17 PM
Subject: [IBO] Re: Using parambyname('param').asstring stop the sequence.


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.