Canceling A Query in MS SQL Server 6.5

Kwan Tsan

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Canceling A Query in MS SQL Server 6.5

I would like to be able to Cancel long running Queries running again a
MS SQL Server 6.5 database using Delphi 3.0(No ODBC ). Does anyone have
any suggestions, ideas ? Example code would be very helpful.
Thanks in advance.

Laurent ANTOIN

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Canceling A Query in MS SQL Server 6.5

You don't break your SQL, the OnServerYield is only for Sybase. In MSSQL you
can setup MAXQUERYTIME into your BDE
Laurent

Quote

Kwan Tsang wrote in message <35571CB6.22D93...@nscorp.com>...
>I would like to be able to Cancel long running Queries running again a
>MS SQL Server 6.5 database using Delphi 3.0(No ODBC ). Does anyone have
>any suggestions, ideas ? Example code would be very helpful.
> Thanks in advance.

Imran Hussai

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Canceling A Query in MS SQL Server 6.5

I think you can only do that if you call ODBC API directly by using the
SQLCancel function.

Imran

Quote

Kwan Tsang wrote:
> I would like to be able to Cancel long running Queries running again a
> MS SQL Server 6.5 database using Delphi 3.0(No ODBC ). Does anyone have
> any suggestions, ideas ? Example code would be very helpful.
> Thanks in advance.

--
===========================================
Imran Hussain
MCP, MCSD
imr...@summitdata.com
http://www.summitdata.com/imranh
===========================================

Andreas Dahlstr?

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Canceling A Query in MS SQL Server 6.5

Have you checked BDE callbacks? They can be used to show query progress and
perhaps for canceling as well...

Quote

Kwan Tsang wrote in message <35571CB6.22D93...@nscorp.com>...
>I would like to be able to Cancel long running Queries running again a
>MS SQL Server 6.5 database using Delphi 3.0(No ODBC ). Does anyone have
>any suggestions, ideas ? Example code would be very helpful.
> Thanks in advance.

Kwan Tsan

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Canceling A Query in MS SQL Server 6.5

I have looked into this, but the cbCancelQuery only works with Sybase and I am
useing MS SQL Server .

Quote

Andreas Dahlstr?m wrote:
> Have you checked BDE callbacks? They can be used to show query progress and
> perhaps for canceling as well...

> Kwan Tsang wrote in message <35571CB6.22D93...@nscorp.com>...
> >I would like to be able to Cancel long running Queries running again a
> >MS SQL Server 6.5 database using Delphi 3.0(No ODBC ). Does anyone have
> >any suggestions, ideas ? Example code would be very helpful.
> > Thanks in advance.

Other Threads

1. MS SQL Server 6.5, Queries and Performance.

2. Cancel Query in MSSQL Server 6.5

3. MS SQL 6.5 vs Local SQL Query

4. MS-SQL server 6.5 vs Interbase server ???

5. D2 SQL Links and MS SQL Server 6.5

6. A good book on SQL (for MS SQL Server 6.5)

7. MS SQL Server 6.5/Delphi 1/SQL Links/Batch Move Problems

8. Installing sql-links for MS sql server 6.5

9. MS-SQL 6.5 & MS-SQL 2000

10. Help: Upgrading from MS SQL 6.5 to MS SQL 2000