Re: Customizing the Forms 4.5 Oracle logon screen

We do not show the default Oracle logon screen at all; we provide our own where we have prepopulated the Oracle username, and provide a radio button for the user to select the database.

I don't have the program in front of me, but I believe it goes like this...

On the Pre-logon trigger of your real form, display your logon form (a modal form) through an open_form call. On the logon form, have the username and password fields, a 'Connect' button and a CANCEL button. When the Connect button is pressed, do the forms procedure LOGON(...), and set a global variable, and EXIT_FORM. CANCEL will set the global to a different value, and not attempt the logon. In the real form, check that the global is set to the connected value. If not, do an EXIT_FORM there, or you will get the Oracle logon screen. (You might be able to check some GET_APPLICATION parameter to see if the connection was successful instead of using the global)

Hope that helps
Dan Received on Thu Jun 19 1997 - 00:00:00 CEST