Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tables gets deleted in Windows 10
Message
De
10/11/2016 14:31:51
 
 
À
10/11/2016 13:07:18
Sonny Tabano
Trams Printwork, Inc.
Mabalacat, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01643029
Message ID:
01643102
Vues:
63
>Hi Naoto,
>
>The remaining disc space is 12GB and yes there is a PACK performed with the program. After the user logs out, the program would delete that user name from the table then perform a PACK on that table and the size of the table is only 3KB
>
>Thanks for the reply,
>
>Sonny

PACK effectively does the following:
1. Copy records in table to a temporary file -- excluding records marked with the DELETED() tag
2. Close the original DBF
3. Delete the original DBF
4. Close the temporary file
5. Relocate the temporary copy made in step 1 to location of original file and give it name of the original file
6. Open the relocated file

One way it could go wrong is if the antivirus happens to interrupt the above-mentioned steps and blocks the program from accessing the file (typically between where the file is closed and when it is re-opened or processed in some manner, such as renaming or relocating it). One thing you might try is to see if you can configure the antivirus to not scan DBF/FPT/CDX as well as ignore the temporary folder.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform