Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Missing Records
Message
 
 
To
28/10/2008 10:47:27
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01357598
Message ID:
01357729
Views:
16
This message has been marked as a message which has helped to the initial question of the thread.
Could it be that you're somehow overwriting the exsiting record with the new information (something like scatter / gather or replace/update) ?

>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.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform