>Hi all,
>In one of my client's deployment of our accounting application, ( 4 XP Prof PCs networked), there was a power failure recently and I was surprised to find that the day's transactions keyed in by the staff completely went missing or some were orphaned. (ie some like sales invoices went completely missing while others, posted to accounting ledger files but the transaction missed out in some of the sub ledgers).
>I had noticed that these transactions were keyed in quite some time (at least an hour ) before the power failure from different terminals). Some of these transactions were even edited before in the individual PCs. ( the client was able to retrieve the records for editing from the terminals that was used to key in ).
>What disturbs me is that I get the feeling that the records were saved only in the cache of the individual PCs but were never written into the PC that's acting as a "server".
>In my code, I use remote views for data entry and all inserts into other tables are wrapped in a complete begin transaction/end transaction cycle with rollback for failures. After each save, flush is issued.
>I had noticed on several occasions that records saved in one PC cannot be seen at all by another PC until the other PCs does an append or something that forces an update of the record pointer.
>I've set refresh to 5,5 or shorter but to no avail.
>Hope there's clues how to debug this.
>Thanks in advance.
>Yau
To back up what ToreB said, VFP6 has a known bug with transactions that exists to this day BUT VFP7 and later have a workaround (SET TABLEVALIDATE) that gives you warning and stops processing when set properly.
Other advice relating to cache should also be heeded.
good luck
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only