OK, for some reason I'm having trouble switching between databases.

We have a main company database and everytime I switch to a sub database, I usually just maximise the new db over it, then for switching back I just minimise the old database underneath it - so you get a pretty fast changeover.

Rather than minimising one, then maximising another window where you get a horrible delay.

In this case however, I'm using troi dialog for some dialog boxes in the sub-database but when I exit from the dialogs and try to switch back to the main database, it does it for a second, then the sub-database re-activates over the top.

I've tried all kinds of script steps - refreshing windows, having about 5 minimize steps in a row, but it still happens.

Anyone had this problem before?

Anyone got any best practice scripts for switching between databases?

This is really starting to bug me - I've taken the script apart and not found anywhere where there could be a problem.

Thanks

Hello there, I nice way to open other databases is by performing an script in database you want to open. i.e Go to layout list.

Hope this will help

Regards,

Willem-Jan

Yeah, I've got it doing that.

Unfortunately the old window suddenly pops back up over it again.

It's being really wierd!!

The script step that calls a script in the target db, or a hide step, must be the LAST step in the original db. Or it must be the last step before an End If that ends the script.

E.g., if you have something like:

hide window

exit script

You will end up back in the original db, the window un-hidden.

I've never had this problem in the past but I'd tried loads of different order of my script steps.

You are correct - I switched the offending if statement to the end of the script and it seems to be working now.

Thanks for that suggestion!!