I have used the Message() command for years to debug everything I have ever written in Forms, so I have created a form that displays an entire test session's messages in one place. The form is called zdebug (the z so it appears last in any list of forms), and I have made it available to anyone who might like to use it.
It handles both Message() messages written from within your form, as well as DBMS_Output messages created in server-side packages and triggers.
Whenever I need to debug a complex situation in a form, I just copy two objects (a procedure and a button) from Zdebug.fmb into my form, and then create messages using my own procedure, AA(), instead of the longer Message() command.
I can compile and run my form, then turn on or off messaging with a mouse-click. Messages can be displayed immediately to the screen, or stored and then displayed all together.
You can download zdebug.fmb, and read all the documentation here:
ZDebug - Forms Debugging Message Tool
If you have any questions or comments, please post them here.
Thanks.
Edited by: Steve Cosner on Jul 31, 2009 4:05 PM
To clean out html tags from the old forum software
Edited by: Steve Cosner on Oct 17, 2012 11:01 PM
New URL -- the web page has been moved.