| 2 Forms on a single page [message #422943] |
Mon, 21 September 2009 06:04  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I'm trying to get two form regions on the same APEX page.
I've created a test page that has an HTML region in which I can enter two text fields, and which also contains a 'Go' button. The button simply re-directs back to the same page, and populated the primary key fields of the other two blocks with the entered values.
There are two form regions, one on each of the two test tables. These simply auto-fetch the record specified by the pk value.
Effectively it's a lookup page, where you can enter some ids, press go, and the relevant records will be displayed.
The problem is that when I specify two id in the HTML region, values are only being returned for one of the Form regions.
Both of the Form regions work fine if I specify only one id, but when I specify two ids, then no value is displayed for whichever form is fetched first.
I'm new to Apex, and a bit stuck here.
I attach an export of the page, and the setup data.
|
|
|
|
| Re: 2 Forms on a single page [message #423464 is a reply to message #422943] |
Thu, 24 September 2009 08:32  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
dear JR,
You are one of the best wizard, i have come across. Technically replying to your query is not possible for me. Still I am perpetual learner of apex, i like to share some of my experiences. I haver sevaral suggestions to solve the problem.
1. If you could create t1_id, t2_id through auto sequence generation, both forms will work since generally so far i did not try to populate the record id or row id through page item. I wrote trigger to populate id value through before insert trigger for the both the tables.
Meanwhile i will import the page sql and see what could be done?
Further i have created multiple forms in single page through different regions and was successful.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
