|Subject||Re: [firebird-support] transactions in nested stored procedures|
> I don't know how a debugger could actually be executing a compiled SPwhile
> tracing through its source code. Perhaps it translates the sources intoYes, it does. Just like the one in Database Workbench.
> DSQL statements and executes
>then rolls back those before moving on...I do believe you get a dialog for this.
Anyway, in Database Workbench, you can also check your procedure
results because you can open a SQL Editor that uses the same transaction
as the debugger, so you can check if anything is inserted, deleted etc...
in the SQL Editor.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL