>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