blank records in database

[riss]

One of our systems is running on an NT network and keeps experiencing blank records in their databases. These records should contain data. Does anyone know how records can become blank (as these are older records and the file is never deleted from the information was there at one time). Could a reindex of data over a wan cause this type of problem, even if no errors occured during the process?

 

[riss]

Sorry, I forgot to mention this is fpd 2.5b

 

[ramani]

I am sure somewhere these files are used as reference along with your regular files. When you do the 'append blank' to your data files or master files used as current files, the default alias could have remained as these older reference files kept open and the records got appended. What I said, may appear silly, but this fact was experienced by me.. and.. that was a bug situation. However to simulate and get that bug out was so complicated, it took years before the user got into such a situation and blank records were noticed.. (almost when the product was getting out! ...)
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[infinitelo]

debug tip - is the file getting larger, then ramani is correct hard to find but no huge deal. otherwise something else is happening (power outages while the file is open, someone is opening the file with and useing cut and paste instead of copy< dont laugh ive seen it happen, or worst of all you may have discoverd yet anohter fine feature{bug} of nt)

 

[fluteplr]

Reindexing will not cause the problem. Various network errors will, if people are still accessing the records. Most often I have seen this with a bad network card on a client or even on the server or other flaky network issues such as bad cabling or excessive cable lengths.

 

[Guest_imported]

We have legacy systems in FoxPro and sometimes have the problem you describe and I have a fix for it. Reindexing will not help. Create a blank structure of your database and then append rescords to it from the corrupted database. For some reason the records that were blank will now have data in them in database you append to. It appears that the append restores the pointers between the records.