I have a Pan6 database file, which works perfectly. I am trying to convert it to PanX. It does things which are very valuable to me.
Many, in fact most of my databases open and close other databases to utilize common macros as FARCALL subroutines. For example, subroutines that solve polynomial equations, or do other more abstract calculations, need only be written and debugged once. And if they need to be changed, I need change them only once in their original file.
But with this approach, how do I know which files depend on which other files?
The database I wrote does the following:
1- It allows me to pick a macro from a list of ALL macros, in every database I want to follow, and shows me which macros and which databases “CALL” that macro. If a macro is not “CALLED” or “FARCALLED” by any other macro, it does not appear in the list.
2- It allows me to pick a macro from a list and shows me what other macros, and which databases, the picked macro itself CALLS.
3- It tells me how any macro is activated - by menu, or by a button on a form. And tells me what button it is, what form it is, and what database it is.
4- It allow me to search all databases macros for any text phrase, and selects all macros with that phrase, shows those macros in a separate text display window (a dropdown menu allows you to pick one), and highlights the selected phrase in bold green to make it easy to spot the phrase.
It took quite an effort to write that Pan6 file many years ago, but I have used it extensively. It basically serves to show connections between all databases I want to follow. A separate database lists those files. I “Update” the file periodically - with a macro. It takes about 30 seconds to run the update.
I’ll bet the experts on this forum could have written this file more easily, and with more elegance. But they wouldn’t have had as much fun as I did when writing it. Or pleasure in watching it work.
Now, to get the darn thing to run on PanX.