Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tables gets deleted in Windows 10
Message
From
10/11/2016 14:31:51
 
 
To
10/11/2016 13:07:18
Sonny Tabano
Trams Printwork, Inc.
Mabalacat, Philippines
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01643029
Message ID:
01643102
Views:
62
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform