> If I am executing a select query via isc_dsql_execute in a background
> thread under Windows, what is the best way to abort the execution if
> the user cancels the operation in a foreground thread? Can I issue a
> rollback on the transaction? Do I just orphan the execution thread
> until it completes? Or is there some other mechanism?
>
> TIA,
> ________________________________________________________
> Richard Wesley Software Engineer

how are you fetching the rows? you can fetch in a loop and interrupt the
loop, then rollback the transaction.
Alan