Home » Developer & Programmer » Forms » simple lov
simple lov [message #221231] Sun, 25 February 2007 20:34 Go to next message
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 Sad

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 Go to previous message
Littlefoot
Messages: 20901
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;
Previous Topic: Problem with a button trigger
Next Topic: converting numbers to hours...helpppp!!
Goto Forum:
  


Current Time: Sun Dec 11 02:33:23 CST 2016

Total time taken to generate the page: 0.11221 seconds