Hello Olaf

[Olaf said]:
I understand. Can I during execution a stored procedure manually commit some
parts?

[Walter say]:
No, you can not. You could to write the commit or the rollback outside the
stored procedure or trigger, i.e. in your application source code.

After the commit the changes are permanents.

Greetings.

Walter.

On Sun, May 8, 2011 at 3:03 AM, Olaf Kluge <olaf.kluge@...> wrote:

>
>
> Hello Walter,
>
> Thank you.
>
> I understand. Can I during execution a stored procedure manually commit
> some
> parts?
>
> If a stored procedure calls a second one, the second commits already if
> finished and the first later if it finished?
>
> Sorry for my questions, but in our project this is very important.
>
> Thanks and many greetings for your helping hand.
>
> Olaf
>
> __________
>
>
> Hello Olaf
>
> A transaction can only be finished with a COMMIT or a ROLLBACK.
>
> You can do several operations (insert/delete/update) into a transaction.
> These operations will be visible to the current transaction but not to the
> other transactions until a COMMIT is executed.
>
> So, in a a stored procedure you can do several inserts, deletes and updates
> and all them will be visibles to the user who did the post, but to nobody
> else. He/she can insert/delete/update several tables, if like.
>
> After the COMMIT the changes will be public.
>
> Greetings.
>
> Walter.
>
> In other words, if I execute a procedure an insert a record in the first
>
> > table and seconds later with the same procedure (one step and the same
> > call)
> > it inserts a record in a second table - the first record is only
> > visible if the procedure finished? (all steps)
> >
> > Thank you
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the main
> (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]