I have found since installing ApexLib 2.0 that I have been having the following issue on my multiselects (I am unsure if this affects other LOV items):
An item with an ID of 10 is returned as 1; however, when I add $APEXLIB_NO_TRIM$ to the comments the ID is returned as 10.
My LOV select is as follows:
select NAME display_value, ID return_value
from PRS_BRANCH
order by PRS_BRANCH.BRC_CODE
where ID is of number(10) in the database.
Any ideas what could be causing this because I know it isn't the Oracle trim(or r/ltrim) function?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have found since installing ApexLib 2.0 that I have been having the following issue on my multiselects (I am unsure if this affects other LOV items):
An item with an ID of 10 is returned as 1; however, when I add $APEXLIB_NO_TRIM$ to the comments the ID is returned as 10.
My LOV select is as follows:
select NAME display_value, ID return_value
from PRS_BRANCH
order by PRS_BRANCH.BRC_CODE
where ID is of number(10) in the database.
Any ideas what could be causing this because I know it isn't the Oracle trim(or r/ltrim) function?
Thanks