Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems
Message
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Miscellaneous
Thread ID:
00110471
Message ID:
00110690
Views:
26
Hi Barbara.

>1. If the pack tries to run on a computer without enough free disk space (one of our tables is over 140MB) I get an error message and after I acknowledge it the program continues to the next table.
>However, all the indexes have been removed from the DBC.

That's a bug in SDT -- it should be checking for disk space prior to deleting all the indexes (which it needs to do before recreating them). Funny no one ever reported it before (then again, in these days of cheap multi-GB drives, I guess that's not so surprising after all). I'll fix that and post an update on our Web site.

>2. This one's much less important. If there's no index the DBF doesn't pack. There is an easy work around - add an index on a small field - but again I'm wondering if I'm missing a switch.

Since the Reindex() method is intended to, you guessed it, reindex, it only operates on tables that have indexes defined. The reason we optionally do a pack at the same time is that packing and reindexing are fairly closely related: when you pack a table, you are really creating a new table with the undeleted records from the original, so the indexes have to be rebuilt.

As Garrett pointed out, it's a good idea to have a tag on DELETED(), and that'll give you the side benefit of having Reindex() also packing the table.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform