Re: Insert new record on update problem

Hi Rag,

With forms if you have block that are based on the database table you will not be able to do this type of action for what I know.

A way that you can treat it, is to remove the update privilege on the block and create a button that will be labelled let said "Update record", This button will have to do the following action:

• Create_record
• Duplicate_record

This new record will then be updateable for the user and you will have your new record.

This is good if you make a query in a base table block (if you prefer: based on a table that exist in the database)

"RAG" <rag_at_trav.se> wrote in message
news:3de7eec5.0211290624.392bbbbe_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 Wed Dec 04 2002 - 19:24:03 CET