how can i tell if a file is open?

[meancode]

hello,

i am trying to add a conditional to my startup scripts.

if main.fp5 is NOT open

...show message "Please start from the Main Menu"

...quit application

else

...do normal startup stuff

end if

in other words i cannot have people starting from the clients.fp5 file, they have to start from the main.fp5 file. how do i do this? thanks.

[djgogi]

Make an startup script in clients.fp5 that simply call the stratup from main.

(this will work only if clients is opened in ortodox way, ie double clicking or open step from an other file)

Also you could use design function DatabaseNames to see what dbs are opened

Dj

[meancode]

well shizam! i never looked into/knew about DatabaseNames. that allows me to determine if the file is open very easily. thanks a lot djgogi!

[Vaughan]

Because some operating systems capitalise file names differently to others, the calculation for the IS statement should be something like:

PatternCount(Lower(DatabaseNames), "filename") > 0