Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New KB Article
Message
 
 
To
21/03/2003 15:16:57
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00768594
Message ID:
00768867
Views:
25
>>I sent through a change request to the article to use Sergey's algorithm of
>>
>>alter table ... add column ...
>>alter table ... drop column ...
>>
>>rather than pack. I like it better, you don't have to worry about losing deleted records if you want to retain them for some reason, and it works even if there are no deleted records.
>
>It seems to me that adding columns will require a significantly greater amount of work than simply adding a record. Rewriting every record in the table twice could have a huge impact on large tables.
>
>Not suggesting one over the other, just realizing the possibilities...
>
>Chris.

I think the best solution would be to use VFP LLFF to correct a file size. It wouldn't require to copy any records at all.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform