Referencing Items in a Tabular Form (Updateable Report)

611580

Problem 1:
I'm having difficulty to populate one Select List Item depending on other Select List Item value in HTMLDB Tabular Form (Updateable Report). It has been a long time I'm trying this.
So if anybody having any idea on how to do this, pls post it. It will be highly appreciated.

Problem 2:
Also is there any method to find out which rows are getting updated in Tabular Form? , while updating one or more records.


Thanks in Advance.

-Sudipta Gupta

Iloon Wolff-Oracle

Hi,

Have a look at: http://htmldb.oracle.com/pls/otn/f?p=20297:13:3512503096593871

611580

Thanks iellen, Thanks a lot for this. But it seems that i need to learn some sophisticated ajax or javascript for this.

Can you give any idea on identifying all rows which are getting updated while i'm updating one or more records in the report?

Thanks for your help.

-Sudipta

Iloon Wolff-Oracle

I found an example for you
http://www.inside-oracle-apex.com/2006/11/generic-solution-for-depending-select.html

Kind regards,
Iloon

Denes Kubicek

If you want cascading select lists in a tabular form, there is no way arround javascript and ajax. See this example:

http://apex.oracle.com/pls/otn/f?p=31517:176

Also, for knowing which records get updated you should use checksum. I have a number of examples regarding this issue here:

http://apex.oracle.com/pls/otn/f?p=31517:170

Denes Kubicek
-------------------------------------------------------------------
http://deneskubicek.blogspot.com/
http://www.opal-consulting.de/training
http://apex.oracle.com/pls/otn/f?p=31517:1
-------------------------------------------------------------------