Hi Stewart, this could answer your question : <http://www.sqlite.org/lang_vacuum.html>
try somthing like this (if needed) : global gConID put "VACUUM" into tSQL get revdb_execute(gConID,tSQL) Hope this helps, Christian On 30/12/09 17:42, RevList wrote:
Is there a way to compact a SQLite database from within a Rev application? I have an application that uses a SQLIte database and it grows in size as records are added. The nature of the application is that the database is often purged but the db size does not reduce. I can use a SQLite Manager application to compact the database, but I would rather do this within the application when the database is purged. Thanks in advance. Stewart Lynch -------------------------------------------------------------------------------------------------------------------- This message and any attachments are intended only for the use of the individual to whom they are addressed and it may contain information that is privileged or confidential. If you have received this communication by mistake, please notify us immediately. -------------------------------------------------------------------------------------------------------------------- _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution