Using : Delphi 3, BDE 5.01 and MSSQL 6.5
We want to start a query in a separate thread, giving the user an
opportunity to cancel the query.
Does anyone knows how to accomplish this ??

Kind regards
   W.Entrop

W.Entrop,

   Unfortunately, there is no way to cancel a running query using the BDE.
Not even in a separate thread.  Check out ODBCExpress, it has a method that
you can cancel a running query.  Perhaps Inprise might work that feature
into a new release of the BDE if enough people request it.

Good luck,
krf

Thanks for the tip and the fast response, ODBC express looks very promising!

The architecture of the database network client driver determines whether a
query can be canceled from another thread, not the BDE.  If the network
client driver supports this functionality, you should be able to take
advantage of it in Delphi because the BDE exposes native handles through the
DbiGetProp function.

For example, the Oracle SQL*Net driver supports the "obreak" OCI function
specifically to break queries asynchronously.  I don't know whether the SQL
Server client driver has an equivalent.

V/R
Russell L. Smith