Sunday, 29 June 2008

Two Tabular Forms on one Page

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:

Stew said...

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!

Graham MacLeod said...

Hi Denes. Do you know of any way to do this without writing your own plsql?

Denes Kubicek said...

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

David said...

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

Denes Kubicek said...

I am using ROWNUM and no ROWID in my example.

AI said...

Hi Denes, Are you using iframes to show the 2 tables on same page?

Thanks.

Denes Kubicek said...

You can use dynamic actions and report region partial refresh instead of submitting and reloading the whole page.

Denes

Anonymous said...

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

Unknown said...

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