Hi!
You cannot. You have to do a maintenance of the database periodically - using PACK command for each table opened exclusively. This will remove records marked for deleting, as well as compact the FPT file. Many applications have a little service running each night at the server. This service does such operations automatically.
I do not know if you can use PACK command through SQLExec(). Probably yes, but this could be done only by running the SP in the VFP 7.0 database using ADO and OLE DB provider for VFP 7 database.
HTH.
>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 ....
>
>Best Regards,
>
>Justy Chow
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.