Re: [libreoffice-users] Command to clean-up LO Base Database.

On 07/04/13 13:53, Dan Lewis wrote:
> Answer in a paragraph:
>      "When SHUTDOWN is issued, all active transactions are rolled 
> back. A special form of closing the data-
> base is via the SHUTDOWN COMPACT command.

Thanks Dan

That's exactly what I was trying to remember!!

I had - with only half my brain switched on!! - looked in the LO Base 
material I have here not thinking that although the Command is issued in 
LO Base it is sent through to the DB engine!!

Don't worry about sending me the HSQL Manual Dan as I have converted 
totally to MySQL, (which is FAR superior), and only maintain the old 
Database for cross checking etc. - But I appreciate the offer.

Thanks again and all the best!!

IanW
Pretoria RSA


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted