Re: Compact SQLite database

2010-01-01 Thread RevList 
Christian Langers ch...@whitelotus.on-rev.com on December 30, 2009 at
10:09 AM -0800 wrote:
try somthing like this (if needed) :

global gConID
put VACUUM into tSQL
get revdb_execute(gConID,tSQL)

Worked like a charm.  Thank you.
Happy New Year to all.


**
Stewart Lynch
CreaTECH Solutions
sly...@createchsol.com
604.484.8499
Skype:StewartLynch

There are only 10 kinds of people.  Those who understand binary and those
who don't.
**


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

Re: Compact SQLite database

2009-12-30 Thread Christian Langers 

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