Macro - Compact on Base closing ?

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
arfgh
Posts: 566
Joined: Tue Mar 05, 2013 6:44 pm

Macro - Compact on Base closing ?

Post by arfgh »

Hey there friends.
Just a question i was thinking today... is it possible to execute the classic 'shutdown compact' from macro when we are about to close base ?

i have seen that with the db working the file is gaining more and more filesize, and the way to normalize that is using that command on sql 'shutdown compact'. But i have tested it a bit an i was no able to achieve its execution via macro.... for some reason that is escaping to me just now.

what you think about ?
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro - Compact on Base closing ?

Post by Villeroy »

You pretend to be the big macro coder. Where is the problem?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
arfgh
Posts: 566
Joined: Tue Mar 05, 2013 6:44 pm

Re: Macro - Compact on Base closing ?

Post by arfgh »

Anybody can throw some way to do it ? thx in advance
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro - Compact on Base closing ?

Post by Villeroy »

How to run an SQL command from StarBasic? Come on!
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
arfgh
Posts: 566
Joined: Tue Mar 05, 2013 6:44 pm

Re: Macro - Compact on Base closing ?

Post by arfgh »

nobody called you to this thread, go to find idiots on other thread.
OpenOffice last version | Mageia Linux x64 | Ubuntu Linux | Windows 8.1 Enterprise x64 | Java last version
Post Reply