Re: Want to insert new record on update...
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