Page 1 of 1

Macro - Compact on Base closing ?

Posted: Tue Apr 09, 2019 4:36 pm
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 ?

Re: Macro - Compact on Base closing ?

Posted: Tue Apr 09, 2019 7:00 pm
by Villeroy
You pretend to be the big macro coder. Where is the problem?

Re: Macro - Compact on Base closing ?

Posted: Thu Apr 11, 2019 12:45 pm
by arfgh
Anybody can throw some way to do it ? thx in advance

Re: Macro - Compact on Base closing ?

Posted: Thu Apr 11, 2019 1:09 pm
by Villeroy
How to run an SQL command from StarBasic? Come on!

Re: Macro - Compact on Base closing ?

Posted: Thu Apr 11, 2019 1:18 pm
by arfgh
nobody called you to this thread, go to find idiots on other thread.