I am (still *grrrr*) using IBX components. The insert procedure transaction
is set at read - write consistency. Multiple queries and stored procedures
run in sequence to select the data required for the shift close procedure.
I am still checking, but some of these will do some updating, yes. There
are linked tables which also get updated on shift close.

Since we have multiple POSs, each one will set a field in a fuel sales
table called "LOCKBYPOS", which gives the int id of the POS that "owns"
that sale.

When the sale is complete, it is moved from the fuel sales table to the LOG
table.

At 08:39 PM 06/20/2003 +1000, you wrote:

> > Suggestions?
> >
>
>Surely your log data reports are not trying to update any data? or are they?
>Alan
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.489 / Virus Database: 288 - Release Date: 06/10/2003

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