Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tableupdate returns false but data is saved
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00846866
Message ID:
00846915
Vues:
28
>>>I don't know, really, why you have this behaviour. ...
>>
>>Perhaps you should take some steps to avoid index corruption. Mainly, IMO: 1) issue FLUSH after the TableUpdate(). 2) Disable write-cache on your file server.
>
>FLUSH would be easy, I think I'll actually try it, it's just one line to add to the class code.
>Write-cache, that's a problem, I don't know enough about our server to get into that, but our net admin is reluctant to change, the main argument being that we have hundreds of other tables and lots of apps that are OK.
>Thanks again.

My bet is that your Net Admin already has write cache turned OFF on the server.
But modern workstations running (Win2K ans WinXP at least) also have a setting for the hard drive for "Write cache". This should ALWAYS be set OFF (unchecked in the appropriate property of the hardware properties).

cheers
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform