Is there some kind of notification or trigger (a la “.InitializeAuxiliaryDatabase”) that informs when all databases have been successfully loaded?
It would need to be a “programmatic” notification allowing code to be run knowing all the databases have been loaded.
I guess each database could “report in” within each “.Initialize” procedure, but I was wondering if such a mechanism already exists.
TIA
No, there isn’t anything like that.
It perhaps wouldn’t be too difficult to add something like that, but before I even think about that, what application do you have in mind for this? I’d hate to implement something and then find out it wasn’t what you needed. For example, what if an auxiliary database failed to load? Do you not want the trigger to happen? Or maybe you want the trigger to happen whenever Panorama has finished trying to load aux databases, whether successful or failed. Then you could check for failure and act accordingly.
Also, I wonder if what you are imagining would be a feature that didn’t “trigger” until all auxiliary databases were loaded and synchronized. That would be a lot more difficult.
You could do all of this now with a timer, for example check once per second until everything is opened. The timer could be instantiated by the .Initialize code. But I think whether that is a good solution or not depends on what you have in mind.
Mostly, I don’t want to display data until it’s actually available.
But, either my “.Initialize” or your timer idea will be more than sufficient.
I just didn’t want to implement something if it has already been addressed.
(That’s happened more often with Panorama than I’d like to admit … 
)
Thanks!
Mostly, I don’t want to display data until it’s actually available.
I usually use catcherror( in that situation, like this.
catcherror("",... some formula that might not exist yet ...)
In fact, this is such a common scenario that I plan to eventually build this in as an option for Text Display objects.
I agree – this would be a very useful feature.
Using a timer works beautifully.
… and added this to display “Loading …” until everything has completed.
Thanks!
Along these lines, is there a DBInfo() or Info() place where the names of auxiliary databases are stored and accessible programmatically?
(Dang! This has been sitting on the web site and I forgot to hit the “Reply” button! LOL)
Shoot, the documentation for dbinfo( didn’t get updated with this tidbit. But yes, you can use
dbinfo("auxiliaryDatabases",targetDatabase)
Of course as always with dbinfo(, you can use "" if you just want the current database.
W00t!
Thanks! 