APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Duplicate Page Submission

Mike_DNov 25 2009 — edited Dec 3 2009

Hello

I have a form on table for creating new records. The primary key for a record is from a sequence and added by a database trigger (before insert).

I have a problem where users are using the back button on the browser (IE6) and re-submitting the page after making changes thereby creating duplicate records instead of using teh update option provided.

What I need to do is update the initial record with the new details when this occurs, I have looked at changing Allow duplicate page submissions to No but I need a process where the record is update not simply blocked.

Is there a way of using the On duplicate page submissions go to this URL option to do this? or some other option?

Any help would be appreciated.

Apex ver 3.2.0.00.27
db ver 11g (11.1.0.6.0)

This post has been answered by 438381 on Dec 3 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2009

Added on Nov 25 2009

#apex-discussions, #insert, #update

15 comments

2,556 views