LOTOSПардон, забыл уточнить, это нужно сделать программно ... Т.е в форме кнопкой Отмена

sqlbreak()
The sqlbreak() function sends the database server a request to interrupt processing of the current SQL request. You generally call this function to interrupt long queries.
Syntax

mint sqlbreak();

Usage

The sqlbreak() function sends the interrupt request to the database server of the current connection. When the database server receives this request, it must determine if the SQL request is interruptible. Some types of database operations are not interruptible and others cannot be interrupted at certain points. You can interrupt the following SQL statements.
SELECT OPEN ALTER INDEX
UPDATE CREATE TABLE EXECUTE PROCEDURE
DELETE CREATE INDEX
INSERT ALTER TABLE

If the SQL request can be interrupted, the database server takes the following actions:

1. Discontinues execution of the current SQL request
2. Sets SQLCODE (sqlca.sqlcode) to a negative value (-213)
3. Returns control to the application

.....