Subject | TIb_Session with multi-threaded tcp server |
---|---|
Author | davissammybr <davissammybr@yahoo.com.br> |
Post date | 2003-02-16T20:44:16Z |
Hi all,
Im using multi-threaded TCP server using Indy with IBO. A lot of
clients need get informations from my database. e.g. a value of
generic field.
I need use a Tib_Session ?
How can i associate a Tiboquery created on execution time to a
tib_session, and how can i associate a Tibotransaction ( created on
execution time too)to these Tiboquery ?
Im using procedures like it:
Procedure Update_my_table;
Var my_query:Tiboquery;
my_ibotransaction:Tibotransaction;
begin
my_query := Tiboquery.create(self);
my_ibotransaction := Tibotransaction.create(self);
my_query.IB_Connection := My_TIBODatabase;
my_query.IB_Transaction := my_ibotransaction;
With my_query do
Begin
Sql.Add('my update instruction sql...');
ExecSQL;
end;
my_query.Free;
my_ibotransaction.Free;
end;
Thanks,
Sammy Davis.
Im using multi-threaded TCP server using Indy with IBO. A lot of
clients need get informations from my database. e.g. a value of
generic field.
I need use a Tib_Session ?
How can i associate a Tiboquery created on execution time to a
tib_session, and how can i associate a Tibotransaction ( created on
execution time too)to these Tiboquery ?
Im using procedures like it:
Procedure Update_my_table;
Var my_query:Tiboquery;
my_ibotransaction:Tibotransaction;
begin
my_query := Tiboquery.create(self);
my_ibotransaction := Tibotransaction.create(self);
my_query.IB_Connection := My_TIBODatabase;
my_query.IB_Transaction := my_ibotransaction;
With my_query do
Begin
Sql.Add('my update instruction sql...');
ExecSQL;
end;
my_query.Free;
my_ibotransaction.Free;
end;
Thanks,
Sammy Davis.