Thank you very much! Have a nice weekend.



Best regards



Olaf





Olaf Kluge wrote:

> One stored procedure reads a record and do something other. At the end of
> the execution the record is updated. Can it be, that another stored
> procedure or other input change the record in the time between reading
> (select) and changing (during execution from procedure one)? Or how handle
> firebird the execution from some stored procedures at the same time one
> record concerning?

Issue a dummy update for the record you want to "lock" at the very start
of stored procedure. Other transactions would either fail (NO_WAIT) or
wait for first procedure to finish (WAIT).

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================





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