Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fpt file keeps growing when using append
Message
 
 
To
08/07/2003 15:17:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00808175
Message ID:
00808278
Views:
12
Hi Cicilia,

When you delete record with memo field from the table, neither record is physicaly deleted nor space occupied by memo filed is released. You've to use PACK command to remove deleted records and freed space in memo file. Also, it is not clear from your post what command is slow and under what conditions.

>when moving records from one table to another using the Append command the desiered records are moved over, but the memo file keeps growing....and growing and growing, I don't know if it ever ends..... It is also very slow (Maybe that is because of the bloating of the memo file)
>
>I am using the following lines in VFP7
>
>use table2
>Append from table 1 for id = 123
>
>Any ideas would be appreciated.
>
>Thank you Cicilia
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform