Hi Abdulla,
table corruption is most likely caused by bad connections, or someone turning off their computer without exiting.
>Dear all Experts,
>
>I have an application, developed in Vfp8. And using by only two users, but i am getting
>file curruption message most of the times like 'File
has become currupted, file need to be repaired'.
>I m not using Any Data Environment and all the files are treated as Free Tables And i m
>not indexing and not using any Cdx or Idx files at all(but, now i can see cdx files for each tables).
>
>While Doing tha table transactions i m using INSERT,Update and Delete commands.
>
>(Code Sample :
> cEmpCod = 'Abc'
> cEmpNam = 'Xyz'
>Insert Into Values(cEmpCod,cEmpNam)
>like this )
>
>In Main Program set commands are like as follows,
>
>Set Cons Off
>Set Status Bar Off
>Set Autosave On
>Set Sysmenu Off
>Set Brstatus Off
>Set Status Off
>Set Talk Off
>Set Escape Off
>Set Collate To 'MACHINE'
>Set Compatible Off
>Set Confirm Off
>Set Notify Off
>Set Decimals To 2
>Set Exact On
>Set Exclusive Off
>Set Memowidth To 1024
>Set Multilocks On
>Set Point To '.'
>Set Safety Off
>Set Udfparms To Value
>Set Cent On
>Set Status Off
>Set Bell On
>Set Scor Off
>Set Date brit
>Set Dele On
>Set Dohistory Off
>Set Reprocess To .0001 Seconds
>Set Ansi On
>
>But, i recoverd data from currupted file using TABLE VALIDATE Command, But i m affrid
>it will happend agin in future, Bcoz, it all ready happned three times.
>
>Now, i need some experts great and kind help in this regard and any recommanded changes in the
>set commands and coding would be appriciated.
>
>Thanks in advance
>
>Regards
>Abdulla
