On Mon, Jun 15, 2009 at 12:52 PM, jason.berry62<jason.berry@...> wrote:

> For example if the SQL statement we wish to stop was a select which had
> already returned the results but had not yet been committed. Can you use the
> 'delete from mon$statements' to effectively cancel the transaction? So that
> the OAT would be released.

No.
If you're using classic you can kill the process that is holding the
transaction open.

Firebird 2.5 will allow you to drop attachments (and it's transactions) using
delete from mon$attachments.

hth,
--
Douglas Tosi
www.sinatica.com