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