Re: Want to insert new record on update...

From: Guido Konsolke <Guido.Konsolke_at_Triaton.com>
Date: Mon, 2 Dec 2002 09:11:16 +0100
Message-ID: <1038816478.853323_at_news.thyssen.com>


Hi,
easiest way I can think of:
use the way that Oracle gives you by default . You can query a record and then invoke the menu command 'copy record'. That will create a new record in the form that looks identical to the queried one. Then you can do your changes to this new generated record. After you are finished with the changes just store the record in the db. Bingo.

hth,
Guido

RAG schrieb in Nachricht <3de7eec5.0212012347.34c8575_at_posting.google.com>...
>Hi,
>
>I'm new to forms and I have come upon a problem...
>
>I want to use the existing values I got from the query and the changed
>values to create a new record instead of updating the existing one.
>I guess the right place is to do something in the ON-UPDATE trigger
>to make it insert a new record instead of updating the existing one.
>But I just can't make it work! Any help is appriciated...
>
>/RAG
Received on Mon Dec 02 2002 - 09:11:16 CET

Original text of this message