Home » Developer & Programmer » Forms » simple lov
simple lov [message #221231] Sun, 25 February 2007 20:34 Go to next message
Messages: 13
Registered: February 2007
Location: manchester
Junior Member


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!!


[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
Messages: 21128
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:
Previous Topic: Problem with a button trigger
Next Topic: converting numbers to hours...helpppp!!
Goto Forum:

Current Time: Mon Jul 24 12:00:04 CDT 2017

Total time taken to generate the page: 0.06427 seconds