mrsam3
asked on
Filemaker statuscurrentfilesopen??
I am making a copy of a solution in filemaker and I want my user to open them all up but i am restricted to 50 databsaes. Is there a way for a script to detect how many databases are currently running in FM6. That way if it's getting high I can auto close the oldest one they have open?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think lesouef meant the function DatabaseNames. You can also use ValueCount on the resulting list to find out how many there are. The RightValue (databaseNames;1)function will get the last one for you.
JJ thinks correctly about what I think! sorry JJ, my fm6 is french only, so translating is always a bit risky.
And ValueCount in fm6 reports the way the field is formatted in a given layout, so this maybe different from the amount of lines in the list. (note this is different in fm8, this is why I am counting returns)
And ValueCount in fm6 reports the way the field is formatted in a given layout, so this maybe different from the amount of lines in the list. (note this is different in fm8, this is why I am counting returns)
Hmm FM6, so long ago! :) I believe, though, that you are right lesouef. RightValues() and ValueCount() were not available in FM6. You are stuck with counting carriage returns.
there is something which could be ValueCount, fr=ETAT ( NombreValeur ) but this is definitly what I described above in fm6.
And if you convert to fm7, it becomes Get(ActiveRepetitionNumber ), which is quite different because the active repetition number is not necessarily the amount of repetitions available on the layout.
Now you can understand why some people are very reluctant to migrate their fm6 databases!
And if you convert to fm7, it becomes Get(ActiveRepetitionNumber
Now you can understand why some people are very reluctant to migrate their fm6 databases!