Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » 2 Forms on a single page (Apex 3.2.1, Oracle 10.2.0.4)
2 Forms on a single page [message #422943] Mon, 21 September 2009 06:04 Go to next message
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 Go to previous messageGo to next message
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.

Re: 2 Forms on a single page [message #423491 is a reply to message #422943] Thu, 24 September 2009 12:18 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
./fa/6802/0/unable to import and install your application page at my home. i am attaching error page. If you have an access at apex demo server, you shall import your application and give me the url.
  • Attachment: error.JPG
    (Size: 139.71KB, Downloaded 504 times)
Re: 2 Forms on a single page [message #423637 is a reply to message #423491] Fri, 25 September 2009 16:04 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
See if you spot a solution at one of these.

-- Carl Backstrom (RIP)
http://apex.oracle.com/pls/otn/f?p=11933:136

-- mark's playpen
http://apex.oracle.com/pls/otn/f?p=200801:1

-- Denes Kubicek
http://apex.oracle.com/pls/otn/f?p=31517:219

Else ask here...
-- OTN Apex forum
http://forums.oracle.com/forums/forum.jspa?forumID=137
Previous Topic: Trouble using Tomcat, Cocoon and FODesigner
Next Topic: open links in the same session
Goto Forum:
  


Current Time: Fri Sep 30 12:27:07 CDT 2016

Total time taken to generate the page: 0.10666 seconds