Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is the Pack command really dangerous?
Message
De
12/12/2000 14:13:49
Steven Herbin
SNH Computing Corporation
Swan Lake, New York, États-Unis
 
 
À
11/12/2000 23:00:12
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00451943
Message ID:
00452415
Vues:
31
>>I've read warnings about using the PACK command to delete records.
>
>I have too, never heard about them actually happening though.

Two weeks ago I was at a client's site. They had a problem with a program not acting correctly and I traced it down to how a deleted record was being treated. So I figured that packing the file would be a good solution (the program is very old and FPDOS and being rewritten in VFP). The file is on an NT Server. I opened the file in FPWin2.6 and packed the file. I got an error that the file doesn't exist when I issued the use command to close it. Then FPWin got an internal consistency error and just disappeared. When I went to look at the file, the DBF simply disappeared and the CDX was still there. Beats me as to what happened. Of course I had the file backed up (after hearing the horror stories). So, I copied the files to my development machine and used VFP to pack the files then copied them back to the NT Server.

What happened, who knows. But now you've seen a horror story...and it could have been worse.
Steven Herbin
SNH Computing Corporation
Swan Lake, NY
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform