In my 7 years of programming, I've always attributed data corruption to 'hardware' problems. Does anyone have any more specific information on what causes data (either an individual or a set or records) to appear as lines or squares and indexes to be rendered useless. Thank you.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
What causes corrupt data in VFP table records?
- Thread starter bkamajian
- Start date
HI
Other than power failure...
Often, the data is not written to harddisk. The data is held in a buffer (The operating system does that working along with other system setup). For the VFP the job is done. But the system holds it in its buffer. SO if the power is lost or computer put off at that stage without operating system clearing the buffer with the flushing of data into harddisk.. the corruption occurs. SO you can use FLUSH command to complete the writing to harddisk.
Another method available now is TRANSACTION PROCESSING. Undr this, an auto rollback will take place if power fails and so these days, I can say.. the corruption in a well written programme is almost NIL.
Hope this helps you
ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Other than power failure...
Often, the data is not written to harddisk. The data is held in a buffer (The operating system does that working along with other system setup). For the VFP the job is done. But the system holds it in its buffer. SO if the power is lost or computer put off at that stage without operating system clearing the buffer with the flushing of data into harddisk.. the corruption occurs. SO you can use FLUSH command to complete the writing to harddisk.
Another method available now is TRANSACTION PROCESSING. Undr this, an auto rollback will take place if power fails and so these days, I can say.. the corruption in a well written programme is almost NIL.
Hope this helps you
ramani :-9(Subramanian.G),FoxAcc, ramani_g@yahoo.com
A good article on this is topic is on Craig's site - Check out "Avoiding Table and Index Corruption".
Rick
Rick
- Status
Similar threads
