On Fri, May 6, 2011 at 5:29 PM, Olaf Kluge <olaf.kluge@...> wrote:

>
> How can I insert data in more than one table and commit both the same time?
> Both tables should have the new data at the same time.
>
> In procedures I don't know a command like "commit" or "rollback". We are
> using firebird 2.5 for this project.
>

You issue the commit or rollback in the client application, or use execute
statement to construct a commit inside a procedure. Procedures do not
normally include commit or rollback statements by design, because the
model is that the client determines the fate of changes. Having client-side
operations committed or rolled-back as a side-effect of running a procedure
makes it harder to develop reliable applications.


Good luck,

Ann