Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table corruption happening frequently...
Message
From
01/06/2005 01:26:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Table corruption happening frequently...
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01018879
Message ID:
01018879
Views:
81
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
Next
Reply
Map
View

Click here to load this message in the networking platform