Subject Re: [firebird-support] Re: Triggers suitability
Author Ann W. Harrison
yeohray wrote:

> Would there be a problem if after the sp has read the records but
> before the deletion, additional records for the item are inserted
> into the table? How can I ensure that the deletion only applies to
> the records that have been read by the cursor, and not to all
> records? Thanks.

As long as you don't use the read-committed transaction mode, the normal
transaction management will insure that the procedure sees a consistent
state of data and won't delete anything it didn't use in the sum.