Board index » off-topic » threads and BDE components - ?

2003-11-25 05:40:31 PM
off-topic9
Hi,
In the article 'Performing database queries in a background thread'
bdn.borland.com/article/0,1410,16231,00.html it says that
each TQuery must have its own Tsession.
Is it also the case if:
- I have the same TQuery performing different SQL queries sequentially, one
after another?
- I have 2 TQueries open simultaneously (so I open 1st query, then open
second, then close first and second). Do these 2 TQuery ought to have each
own separate session? Or one will do for both?
 

Each thread needs its own session. If the queries are executed within the
same thread, they can both use the same session. The example in the article
creates 2 threads, therefore 2 sessions are required.
Personally, I create and destroy the session within the thread ...
In the constructor
ASession := TSession.Create(NIL);
ASession.SessionName := 'Id'+IntToStr(ThreadId);
ASession.Active := TRUE;
and destructor
ASession.Active := FALSE;
ASession.Free;
I use the ThreadId to ensure a unique SessionName. Prior to executing the
query, I assign
TQuery.SessionName := ASession.SessionName
within the thread.
Regards
Mike
 

Thanks a lot!
"Matthew Noordermeer" < XXXX@XXXXX.COM >schreef in bericht

{smallsort}

Thanks!
"Bill Todd" < XXXX@XXXXX.COM >schreef in bericht