This content has been marked as final. Show 18 replies
If I understand your question correctly, you want to update a database table on change of a pre-defined select list?
Why can't you use a dynamic action for this? You can execute a pl/sql code on change of the select list value.
any body can advice me about this issue .how to update table when
change select list in classic report(report column display as select list from love
Are you talking about tabular form or updateable report?
updateable report.I change the display column report to select list to update table
Can you post your report query? If possible, please setup an example in apex.oracle.com.
thanks for prompt replay ,
i create simple example to show what i need ,i create report show all employee and i want when change the department name update the table with new dept
username/password : test/test123
hi Rohit,thanks for prompt replay , i create simple example to show what i need ,i create report show all employee and i want when change the department name update the table with new dept http://apex.oracle.com/pls/apex/f?p=54167:1:26791991047433:::::username/password : test/test123regards Ahmed
Can you post the query, you used for the demo application?
That would be helpful.
i don't use APEX API to create report i create normal report with wizard and the query
select EMP.EMPNO as EMPNO,
EMP.ENAME as ENAME,
EMP.JOB as JOB,
EMP.MGR as MGR,
EMP.SAL as SAL,
DEPT.DEPTNO as DEPTNO
from DEPT DEPT,
} then i change the column attributes of dept no to Display as Select list(named lov).
Can you share your workspace name?
I coded the following to give you direction:1 person found this helpful