Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select List to check duplicate values before putting into another item

533006Mar 5 2007 — edited Mar 7 2007
Hi All ,

I have a select list which contains .. country regions like ( APAC , EMEA etc ) .
When I select any region , all the countries belonging to the region fills in another item .
Suppose I select APAC , all the countries like India , Japan etc all fills in another item .

But the problem is , if I select twice APAC , it fills duplicate values . Its filling duplicate values .

I want to put validation or check for country value ...
Suppose I select ' APAC ' it fills all APAC countries in another item . Now Again If I select APAC then it first check the item whether the country is there or not . If already APAC countries are there in the Item then it will show an error message that " Value already Exist ' .

I am not able to fix this problem . it is creating duplicate values in database table .

Please some one help me on this ..

Thanks

Prashant
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2007
Added on Mar 5 2007
22 comments
1,636 views