Home » Developer & Programmer » Forms » duplicate values in list item (forms 6i)
duplicate values in list item [message #364722] Tue, 09 December 2008 16:27 Go to next message
Messages: 9
Registered: April 2008
Junior Member
I have created a list item and populated it from v$timezone_names.

The items are displaying correctly but when I select an item it shows as if I selected something different.

As an example the first few entries in this table are:
Africa/Algiers / LMT
Africa/Algiers / PMT
Africa/Algiers / WET
Africa/Algiers / WEST
Africa/Algiers / CET
Africa/Algiers / CEST
Africa/Cairo / LMT
Africa/Cairo / EET
Africa/Cairo / LMT

When I select the first 'Africa/Cairo' it displays 'Africa/Algiers', I am assuming because they have the same value in the second column. How do I avoid this from happening?

Also, when the items are displayed it is showing TZNAME, what I would like is 'TZNAME: TZABBREV' to show as the value in the pop list, is that possible?

thanks in advance
Re: duplicate values in list item [message #364784 is a reply to message #364722] Wed, 10 December 2008 00:50 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do you have other triggers on these items? You have defined both items that you want populated in the LOV definition haven't you?

Previous Topic: My OC4J instance stopped working
Next Topic: FRM Error Codes
Goto Forum:

Current Time: Fri Jul 21 23:56:56 CDT 2017

Total time taken to generate the page: 0.04447 seconds