In Firebird 2.5, we introduced new API function, fb_cancel_operation().
This API call takes a database attachment handle as its parameter, and calling it will cancel all operations on that database handle.
I would like the ability to cancel just the work on a statement handle, instead of whole database attachment. This would be especially useful for ODBC drivers or applications.
A new API could be provided, fb_cancel_handle()?, or perhaps fb_cancel_operation() could be extended. The API would be very similar to the ODBC API call, SQLCancelHandle ().