Re: [firebird-support] Explicit Transaction + Suspend

2016-11-25 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Nov 24, 2016, at 2:59 PM, fabia...@itbizolutions.com.au [firebird-support] > wrote: > > Just wondering can my app start a transaction with Begin Transaction and > then call a stored procedure that contains the SUSPEND sentence at the end > while the

Re: [firebird-support] Explicit Transaction + Suspend

2016-11-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.11.2016 19:59, fabia...@itbizolutions.com.au [firebird-support] wrote: > can my app start a transaction with Begin Transaction and > then call a stored procedure that contains the SUSPEND sentence at the end > while the transaction is still opened? SUSPEND has nothing to do with

[firebird-support] Explicit Transaction + Suspend

2016-11-24 Thread fabia...@itbizolutions.com.au [firebird-support]
Just wondering can my app start a transaction with Begin Transaction and then call a stored procedure that contains the SUSPEND sentence at the end while the transaction is still opened? Is there any special consideration when comencing a transaction other than to ensure the process finished as