Hi,

At January 27, 2006, 1:00 AM, Mitch Peek wrote:

> Each person is issued their own till. Therefore, all transactions point
> to that till, and all transaction details and payments point to those
> transactions. Therefore, no chance of two users updating the same row
> at the same time or otherwise, for that matter. If they did, I would
> have had much bigger problems!

When each person is issued their own till, do they have to enter the
till number themselves or is it a automatically assigned? And, if
it's automatically assigned, how is it assigned? Is it the
application that generates the till number or is it a generator?

Obviously the error is when at least 2 transactions are trying to
modify the same row, so the best way to try to find the problem is to
actually try to recreate it and perform a trace to see what the data
that is being transferred and for which operation(INSERT, UPDATE,
DELETE or SELECT). Although you say that it should never happen, it
doesn't mean that it will never happen, because it did.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)