Re: Insert new record (Forms 6.0 )

"A. Bogomol" <bogomol_at_investbank.ru> wrote in message news:9455EAF0C99FD111B85B0060B067688A04A4D719_at_E40...
> Hi folks!
> When user changes record in the block,after commit_form operation the new
> record should be inserted in the table of this block . The new record has
> the changed values and values of the old record.
> I've created Key-Commit trigger that has the following code for my form:
>
> rec:=:system.cursor_record;
> create_record;
> duplicate_record;
> go_record(rec);
> clear_record;
> commit_form;
>
> So I have a new record in the block and after commit operation there will
> be two records in the table (old and new).
> I think my way is not very pretty.
> Does anybody know the other way to perform this operation?
>
> Thanks in advance.
> Alexander

Use the ON-UPDATE trigger to override the standard update statement that Forms generates and override it with your own INSERT statement.

-Matt Received on Mon Feb 19 2001 - 02:21:47 CET