Hi Tim,

> The shift close procedure can take several minutes (between 30 s and 4
> minutes) to complete. During this time, if I am trying to insert a new
> sale, I get a no wait lock conflict.

As longs are your procedure doesn't update any rows, your
"readers" should be fine.

what's the transaction isolations that you're using?


With regards,

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