This content has been marked as final. Show 6 replies
Can you not use a List of Values for your column. That way you can have a display value as and a return value. You can either use a static list similar to below or dynamic list that would query a table:
STATIC:Yes;1,No;2 (show Yes / No, return 1 and 2)
Query based dynamic:
Select ename as display, empno as return from emp
Hope this helps
i created a dynamic lov for vendor_name
select vendor_name d,vendor_code r from vendor
that working fine without any issues,problem in tabular form only
whenever i click on submit button only the vendor column not getting inserted in the emp_detail table.
Have you made sure you have the column mapped correctly in your tabular form column, the section I am referring to is under the Tabular Form Attributes.
I am only guessing these table / column names from the information you have given but I believe the fields should contain the below values.
Reference Table Name: emp_detail
Reference Column Name: vendor
If you are still having issues after this if you could give me application builder access on apex.oracle.com I will happily have a look.
workspace name :aneesmohd
user name : firstname.lastname@example.org
application id : 62371
Thanks for those, hopefully I have added the solution for you. Here is what I have done:
Changed your query to:
You can't use to_char(vendor_code) when it is a number column.
select "ROWID", "EMP_ID", "EMP_NAME", "MONTH", "YEAR", "VENDOR_CODE" from "#OWNER#"."EMP_DETAILS"
I have changed the column type to select list query based and added the following query:
Changed the column attributes to:
select vendor_name d, vendor_code r from vendor
Reference Table Name: EMP_DETAILS
Reference Column Name: VENDOR_CODE
This now allows you to save and edit the vendor_code for rows in your emp details table.
When new vendors are added to the vendor table they will be dispplayed in the select list in the tabular form.
Hope this solves your problems
Thanks alot paul..