Macro - Compact on Base closing ?

Creating a macro - Writing a Script - Using the API

Macro - Compact on Base closing ?

Postby arfgh » Tue Apr 09, 2019 4:36 pm

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 - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 443
Joined: Tue Mar 05, 2013 6:44 pm

Re: Macro - Compact on Base closing ?

Postby Villeroy » Tue Apr 09, 2019 7:00 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26751
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro - Compact on Base closing ?

Postby arfgh » Thu Apr 11, 2019 12:45 pm

Anybody can throw some way to do it ? thx in advance
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 443
Joined: Tue Mar 05, 2013 6:44 pm

Re: Macro - Compact on Base closing ?

Postby Villeroy » Thu Apr 11, 2019 1:09 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26751
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Macro - Compact on Base closing ?

Postby arfgh » Thu Apr 11, 2019 1:18 pm

nobody called you to this thread, go to find idiots on other thread.
OpenOffice last version - Windows 8.1 Enterprise x64 - Windows XP x64 SP2
arfgh
 
Posts: 443
Joined: Tue Mar 05, 2013 6:44 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: rztv8076 and 10 guests