Db Maintenance

Ruslan Zasukhin sunshine at public.kherson.ua
Sat Apr 12 00:15:38 CDT 2003


on 4/11/03 9:04 PM, Chuck at rwc1717 at shaw.ca wrote:

> Hi Ruslan:
> So just how do I embed the compact and defragemnt commands inside my
> app.
> I have got it to work using
> dim i as integer then
> i = mDb.SQLExecute("DEFRAGMENT")
> i = mDb.SQLExecute("COMPACT")
> but the literature doesn't tell me what the retrun numbers mean.

SqlExecute() returns "the number of affected rows"

For above 2 commands it have no sense, so simply ignore it.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list