Recently there have been several discussions in the forum regarding multiple tabular forms on one page. I thought it is easy if you know how to create one tabular form manually, you will be able to do it for any other number of those forms. However, many participants of the forum do not share my opinion. This is why I decided to create a very basic example showing how that works. You will find it in my Demo Application together with the required code. If you want to see all the details, you may apply for an account following the instructions on the login page of my Demo Application.
Have fun.
9 comments:
Denes,
Thanks for providing this complete, yet simplified, example. I haven't had to provide multiple tabular forms on a single page (yet), but it's great to have such resources.
- Stew
p.s. Your name and demo app came up a few times at ODTUG!
Hi Denes. Do you know of any way to do this without writing your own plsql?
Graham,
No. Maybe in the release 4.1 which is I suppose going to be here somewhere in the second half of the next year.
Denes Kubicek
Hi Denes,
thanks for the basic good example.
By trying to apply your solution I got the following error after adding the validation:
ORA-01446:cannot select ROWID...
I analysed the Debug-Log and Apex added a column ROWID to the query, after adding the validations. Could this be the error source?
I am working with APEX 4.1.0.00.32.
Any idea?
Thanks in advance
David
I am using ROWNUM and no ROWID in my example.
Hi Denes, Are you using iframes to show the 2 tables on same page?
Thanks.
You can use dynamic actions and report region partial refresh instead of submitting and reloading the whole page.
Denes
Hello! How I can be on the same page, in the same table, a simple form fields and elsewhere in tabular form and be able to insert, update?
I have little knowledge of Apex, but I know PLSQL
Thanks
Ginger
Ecuador
hi as i had displayed the emp form and the dept form in the single page but i was unable to add row or update the row for the both tables please any one can guide me
Regards,
gopichand
Post a Comment