Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table corruption happening frequently...
Message
De
01/06/2005 01:26:42
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Table corruption happening frequently...
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01018879
Message ID:
01018879
Vues:
82
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform