Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any explanation for this weird behavior??
Message
 
To
17/02/2004 11:52:28
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00877939
Message ID:
00878054
Views:
16
>Response #1
>I can see how a corrupted index could cause posting to the wrong account, but I do not see how it would create 7 entries in that account, and then 6 in the correct account in response to 1 customer entry.???
>
>Response #2
>The tag does exist and is still operative.

Are other systems accessing the same files as the 98 desktop in question. Or, is the 98 a the only (standalone) user?

Maybe you should go beyond indexing.
-USE the DBF in question
-Delete each tag.
-Pack
-sort to and append back to obtain a physical sort on the "main" key
-Browse and look for blank or duplicate recnums

You might also check for duplicate recnum keys
INDEX on recnum UNIQUE. CHeck the record count for UNIQUE and compare to the good one.

If recnum is an actual record number, and not a user (or system) assigned key, you could get duplictaes as records are deleted and packed.
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform