: Cancel a running SQL query

I'm using Delphi 3 C/S with BDE 4.01 and MS SQL Server 6.5 .

Is there _any_ way to cancel a running SQL query (for example "select * from
MyTable") before it has been processed?

You could cancel the thread that the Query is using, but the database is
still processing the query till the end.... Is there more clever way to
terminate this query?

I have read about dbiRegisterCallback, but is it only working with local
(=Paradox, dBase) tables?

With regrads,