Hi Tim,

> Need some advice. I have a log table in my database, that records every
> transaction passed to it from fuel pumps and points of sale at Petrol

Stations.

>
> So far so good - no problem there.
>
> About once every 8 hours, the shift at the petrol station changes, and the
> system goes through a "change shift" procedure. During this procedure,
> various reports on income, expenditure, stock and fuel levels are drawn,
> based heavily on the data in the LOG table.
>
> This is where the problem comes in. I cannot afford any lock conflicts AT
> ALL - i.e., the fuel pumps cannot stop pumping to accommodate a shift

change.

What lock conflicts?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com