Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One Day
Message
From
17/03/2004 13:42:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
17/03/2004 07:21:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00878450
Message ID:
00887189
Views:
14
>Thank you very much,
>I'm not very well in english languge when I write ENGLISH, but I understand ENGLISH.
>
>What you mean
>an automated process
>I need code to do process

First of all, in a network system, you only DELETE records; you postpone the PACK until nobody uses the system. This can be at midnight. Also if you do NOT use a network, you don't PACK after every DELETE - this is simply too slow.

For the PACK, write a PRG, that gets a list of tables with adir(), and packs them one by one. Then, use Windows Scheduler to invoke your program at midnight. That way, you don't have to go to the office late at night.

Doing the PACK once a month should usually be enough.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform