Re: FORMS_DDL('rollback') - does it makes sense?

[Quoted] On 19 Mar 2004 03:31:22 -0800, rolf.unger_at_ctilabs.de (Rolf Unger) wrote:

>Hi,
>
>I want to do a rollback of my
>
> update table_b set col_a=2 where col_b = :BLOCK_A.col_b;
>
>that I have executed in a "WHEN-BUTTON-PRESSED" trigger.
>
>If I simply do the natural approach and use a "ROLLBACK"
>inside the trigger code, FORMS converts it to the built-in
>"Clear_Form" and all my blocks are empty.
>That's not what I want!

You can tell forms that these records aren't new, so forms won't issue an "insert" or "update".

Set_Record_Property( block_name, 'QUERY_STATUS' ) will do this.

hth

-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net