Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to reduce the size of .FPT file.
Message
From
12/11/2001 14:07:31
 
 
To
12/11/2001 04:04:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00580366
Message ID:
00580571
Views:
15
>Dear all,
>
>I wrote a C/S program and using VFP Database as back-end database. The application will store many remarks on the database. When user deleted some records, the size of memo file remain unchanged. How can I reduce the size when I using SQLExec command to issue the sql statement? Thank you very much ....

In addition to Vlad's comments you can SET BLOCKSIZE TO 0 which can decrease memo field size in some cases.
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
Reply
Map
View

Click here to load this message in the networking platform