| Reload Page With A Specific Record [message #352241] |
Mon, 06 October 2008 14:56  |
greendba
Messages: 22
Registered: September 2008
Location: Toronto
|
Junior Member |
|
|
I have a button on my form that makes an identical copy of the currently displayed record.
When this button is clicked it begins a PL/SQL process that selects all columns from the current record (except the autopopulating trigger fields like UniqueRecordID - URID) and inserts a brand new nearly identical record into the table. EG .."Select col1,col2,col3 into :new.record of table"
This work great so far, but after the process occurs the page remains with the current records data set.
However, what I would like to do is after this process happens I would like to refresh this page with the newly created record so that it can be further edited.
I know how to create an SQL statement that will pull the record I want... I just don't know how to make it happen in the application.
Do I create a secondary process or another page branch?
Thanks for your suggestions.
Eric
|
|
|
|
| Re: Reload Page With A Specific Record [message #353057 is a reply to message #352241] |
Fri, 10 October 2008 15:31  |
greendba
Messages: 22
Registered: September 2008
Location: Toronto
|
Junior Member |
|
|
Can Close this as I figured it out...
Just created a hidden item... used process PL/SQL to set it's value and then on the page Branch for the related button set the key value to the hidden item.
Easy Peasy... After 8 hours!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
