Re: Help needed: SQL*Forms V3. Suppressing commit messages.
From: craig sivils <casivils_at_lescsse.jsc.nasa.gov>
Date: 14 Feb 93 21:51:41 GMT
Message-ID: <casivils.729726701_at_node_508ba>
Date: 14 Feb 93 21:51:41 GMT
Message-ID: <casivils.729726701_at_node_508ba>
In <1993Feb14.125348.8311_at_brt.deakin.edu.au> ajmex_at_brt.deakin.edu.au writes:
>I am using SQL*Forms V3, and have created a form, with no base table, that
>updates several tables (in a key-trigger). How do I supress the message
>"No changes to commit" when I COMMIT inside my trigger?
>Thanks in advance, e-mail prefered, Alister Miller.
Use the following code:
:SYSTEM.MESSAGE_LEVEL := '5';
COMMIT;
:SYSTEM.MESSAGE_LEVEL := '0';
- CRAIG