CompactDatabase() & Vast Deletion of Records
Posted on 1998-04-17
I have a new question regarding CompactDatabase(), how can I use it to
compact my already active database? The Close() function is not enough
to "log off" from the database, & CompactDatabase() still complains that
I am unable to proceed with the operation. Pls teach me how to make it
work? I must make sure that the compacted database will be replacing
the original set.
I will be using CompactDatabase() as a tool to "organise" my database
(smaller size), produce a Backup Copy & Restore a Backup copy. Is what I
am going to do possible with CompactDatabase?
Another question is regarding vast deletion of old records from the
database. I am currently doing deletion of records individually from
the first record of the database. It seems inefficient, is there a
better way like executing some SQL statement? Pls guide on how to pass
in the SQL statement since this time, the SQL statement will be acting
on the main m_pSet. (I noticed that once I Close() the m_pSet,
reopening it doesn't seems to work anymore ??? Purely Open() & Close()
with no params, am I right?)
Lastly, is it possible to change the name of the connected database
while the program is running?