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?