Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why records missing?
Message
De
29/11/2004 16:26:26
 
 
À
29/11/2004 15:21:56
Mike Zhu
Icube Info International
Fremont, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00965517
Message ID:
00965531
Vues:
11
>I have a client use ACCPAC Pro6.5. It use VFP7.0 database. One day they find that 50 records in the "POMAST" table is missing. But for sure these records is there before. I check the table and find one empty record marked deleted after the missing record. And there are some old deleted records on the top. How can it happen? the missing records is really gone, it's not marked deleted. Is bad index can cause this? I delete the index and still cannot see the missing records.
>
>The database is always open by someone, so it's impossible someone open the database exclusive and pack these missing records.

A workstation or server crash, or network or power outage, can cause this.

Setting network redirector and disk cache settings conservatively may help:

Thread#962081
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform