Close all open FMP databases?

[Fritz Jung]

I must be missiong something...

I run hundreds of scripts at night and inevitably I hit the max 50 databases open...

SOOOO ... I fire off close such and such a database scripts in my master script... but maybe I'm blind BUT I just can't find a close all open databases command OR 'Close all but front'

Vanna can I buy a clue?

Fritz

[cjaeger]

you are not blind.

here a way in applescript

tell application "FileMaker Pro"

repeat with i from 2 to 50

if exists window i then

try

close window i

end try

end if

end repeat

end tell

[Fritz Jung]

Sadly (sez THIS 19 year Mac Bigot) this for my paying job as a windows IT guy (don't hurt me).

So applescript is not an option...

I can't believe that FM6 still doesn't have a 'close all but front' command.

thanks anyway.

Fritz

[Vaughan]

I'm sure a script could be made to close all open databases, probably using a loop and the Databases and PatternCount() functions. It's too early in the morning for me to think about it now though!

[Paolo]

"I'm sure a script could be made to close all open databases, probably using a loop and the Databases and PatternCount() functions."

hmmm..

the Close[] script step require that the database is specified trought the standard "open" dialog window. You can't specify it with a calculated value.

Fritz, why don't you set each script to close the used files at the end of the task?

[Fritz Jung]

Thanks much for the responses...

Paolo, I think my best option may be to do some closing at the individual script levels.. and NOT try to do it in the master script.

I really appreciate the responses...