| simple lov [message #221231] |
Sun, 25 February 2007 20:34  |
sophia_786
Messages: 13
Registered: February 2007
Location: manchester
|
Junior Member |
|
|
Hi
I have created a simple LOV, but as im the luckiest person in the world, it obvsly doesnt work 
ok ive used the lov wizard to create an lov and then tested it using select Display List from the Runtime Edit Menu and that works fine.
but when i try to assign a button to call this lov i hit a problem.
i created the button on the same canvas next to the field that the result should return, i then made a WHEN-MOUSE-CLICK trigger and entered the code LIST_VALUES;
and when i run the form and query back records then try to call this lov from the button i get the error frm-41026 Field does not understand operation.
but when i select Display Item from the Runtime Edit Menu the lov appears.
what have i done wrong please help!!
thanks
[Updated on: Sun, 25 February 2007 20:35] Report message to a moderator |
|
|
|
| Re: simple lov [message #221287 is a reply to message #221231] |
Mon, 26 February 2007 03:30  |
 |
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
WHEN-MOUSE-CLICK trigger (btw, why not WHEN-BUTTON-PRESSED?) lacks one more line; the way it is, Oracle doesn't know which List of Values to use. So, your code should look like this:GO_ITEM('block_name.item_that_has_a_LoV_attached_to_it');
LIST_VALUES; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
