Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Missing Records
Message
De
28/10/2008 10:47:27
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01357598
Message ID:
01357694
Vues:
10
Sorry, the version reported on the message header is wrong.
One system is 5.0; the other is 6.0 sp5. Thus no SET TABLEVALIDATE.

Clarification: The record that goes missing was properly recorded at an earlier time. The transaction was printed and a hard copy is in the file. The missing record is as if someone deleted the record and packed the file.

Also, no frameworks are used.

There are error handles on both systems.

Dennis


>What's SET TABLEVALIDATE in the application?
>
>>Two clients: one with a commercial systems with thousands of installations, the other is custom.
>>One app has about 15 users, the other just 2. Both have been running well for several years. Recently we have been experiencing lost records at both clients. It happens about once every week or two. The loss is a single record, ususally a header record in a header/details structure.
>>
>>The file is not corrupted. It opens and processes existing records without problems.
>>
>>I know hardware problems can cause garbage characters to appear in tables, but in this case a complete single record is cleanly gone. I have wondered about possilbe buffering problems with the data in a buffer not being written out for some unknow reason. Any suggestion on how to test this or what ot look for?
>>
>>All thoughts happily accepted, except ungrading the apps to VP9. That's already on my list.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform