The only way I can think of that you launch the query in a separate thread,
which opens it's own connection. And then, you can cancel the execution of
the thread, and close it's connection. The server will recognize (after a
while) that it's dummy pockets won't get back, so it wil close it's
connection also. You can set the Dummy Pocket Interval in the firebird.conf.

SanTa

----- Original Message -----
From: "Zd" <toldy007@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, September 15, 2008 2:26 PM
Subject: [firebird-support] Is there a way to cancel query execution?


> Hi guys,
>
> Is there a way to cancel a SELECT query after it has been launched (and
> while it's being processed by the server)?
>
> I'm providing search functionality in my program, and if the search is
> taking too long (might be) I want to enable my users to cancel query
> execution!
>
> Thanks:
> Zd
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>