That's the way it works for us. It gets even worse because you can't even
kill a thread that has a active query without sometimes causing an access
violation. I'm assuming you are using the BDE.
We have been looking at using ADO instead (replace TQuery with ADOQuery
etc). With ADO it is possible to have multiple queries running and be able
to cancel them with having separate threads or any more connections!
Ant
________________________________________________________
Antony Gardiner (IT Specialist)
Clear Communications Ltd
One of the Intranet, NRS, CPS, & NMS wannabes
(+64 9 912 4746) Zone 1534
-----Original Message-----
From: Lisandro Rueckert [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 18 April 2000 12:18
To: Multiple recipients of list delphi
Subject: [DUG]: Multi-thread queries
Hi !
I'm developing a application that need execute multiple queries concurrently
(only selects) over a Oracle server. So I have some questions about. Thank´s
for your attention :
1) Need I a TSession and TDatabase with different names for each query
that I will execute concurrently ?
Eg : Query1.databasename := 'db1';
Query1.sessionName := 'se1';
Query2.databasename := 'db2';
Query2.sessionName := 'se2';
2) This will cause "n" connections (sessions) with the DB, OK ? (One for
each query executing). So, if i buy a server with ten connections
concurrently and my app use five them, I can only have two app running at
same time ?
Att
Lisandro Rueckert
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
