Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields
Message
From
03/05/2002 05:24:35
 
 
To
03/05/2002 03:24:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00652266
Message ID:
00652280
Views:
20
thank u,
i'll try it, i thought that its default setting was the best for saving space...


>>I realized that replacing a memo field in a record, the size of the .fpt files grows very much. to reduce it i have to pack it. Is there any other method to do it as i cannot, or better i prefer not to do it, open exclusively the table to run the pack command.
>>thank u
>>Alessio
>
>If it's large now, and you want to shrink it you need to PACK it, which as you note requires exclusive access.
>
>If you want to reduce the memo size and the rate at which it grows you can try SET BLOCKSIZE TO 0. See the help for SET BLOCKSIZE for further information.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform