I use the following procedure to navigate from one database to another in PanX (this worked until recently - just got back from my Hawaii vacation):
local lvfolder
lvfolder=folderpath(dbinfo("Folder",""))
save
closefile
if info(“files”)="Departments"
opensecret lvfolder+"Departments"
window "Departments:Secret"
opensheet
OpenForm "D Data Entry"
selectall
else
OpenFile lvfolder+"Departments"
Endif
When I run this procedure, it will close the open database (Retention Schedule) and Open the “Departments”. But while in “Departments” I click the procedure to open the “Retention Schedule” – and it doesn’t open. Quitting Pan and clicking either database from the desktop – neither will open. I have to open another database and use the “View Organizer” to reopen both.
I also used my original Pan6 procedure just to double check:
local lvfolder
lvfolder=folderpath(dbinfo("Folder",""))
OpenForm "Data Entry"
NoWindowSave
Save
CloseFile
OpenFile lvfolder+"Departments"
It closes the active database and opens the one I want, but the database I closed will no longer open - unless I use the view organizer.