Using the LOGON built-in
Users want to see a splash screen before logging into the application. So I created my own logon screen. The LOGON built-in takes three parameters: username, password@db, and logon_screen_on_error. logon_screen_on_error defaults to TRUE. However that means if the user fails to connect, Forms pops up the error window and when the user clears the message, Forms pops up its own logon screen. When I set the logon_screen_on_error parameter to false, Forms sets FORM_FAILURE to TRUE if the user fails to connect. Now it is up to me to advise the user of the problem. In this situation, SQLCODE and SQLERRM are all happy, as if nothing went wrong: SQLCODE = 0 and SQLERRM = normal... Also, ERROR_CODE = 0 and ERROR_TYPE is NULL and ERROR_TEXT is NULL.
How do I find out what went wrong? If logon_screen_on_error = TRUE, the messages come back correctly. But I don't want that second logon screen.