Hi,
Oh yes. I trap for a false outcome then do a messagebox() prompt. None of this sort has ever surfaced so far.

>Hi All,
>>
>>This is by far the weirdest that has happened to me.
>>
>>In my POS app, I have the following cursoradapters - ORDERHDR, ORDERDTL (Orders header and detail), INVHDR, INVDTL (Invoice header and detail)
>>
>>Whenever a customer orders something, it is recorded into both ORDERHDR and ORDERDTL cursors.
>>
>>When order has been read out and confirmed, it is now SAVEd (read: TABLEUPDATE()/ MySQL COMMIT is done), and the ORDER details in ORDERDTL is appended into INVDTL (invoice details) which in turn is also SAVEd ((read: TABLEUPDATE()/MySQL COMMIT is done). The header tables INVHDR and ORDERHDR are of course also SAVEd together with them; the header records contain info such as child totals and record count.
>>
>>All is well, but there are days when the daily sales totals do not tally - upon closer examination, we found out that a couple of orders/invoices have no ORDERDTL and INVDTL child records! The header records though show that it had recorded summary totals which come from both ORDERDTL and INVDTL records!
>>
>>There are three POS machines; the common thing is that it happens on the 2nd and 3rd machines. We also noticed that this happens consecutively (two or three in a row) if it ever does. There are days that are incident free though.
>>
>>I do not know if this is a factor, but the 2nd and 3rd machines were assembled from old PC parts.
>>
>>My question is, how is this even possible?
>
>Do you check the return value of TableUpdate() and confirm that it worked?
>
>Tamar