General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only