Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo fields
Message
From
03/05/2002 03:24:54
 
 
To
03/05/2002 03:13:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00652266
Message ID:
00652267
Views:
21
>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.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform