Home » Developer & Programmer » Forms » Please Help LOV
Please Help LOV [message #82358] Wed, 21 May 2003 02:55 Go to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi,

Please help me in displaying LOV items.
I have a table contains following data.
CODE
A001
A002
A003
A004
....

I have created Record Group
SELECT CODE
FROM TABLE1
WHERE CODE=:VCODE;

I am directly passing values into :VCODE, when the value is A001,A002... it is displaying perticular item in lov. But If I won't supply any :VCODE it should display all CODES.

Thanks in Advance....

Syed Muzzammil.

Report message to a moderator

Re: Please Help LOV [message #82361 is a reply to message #82358] Wed, 21 May 2003 03:43 Go to previous message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Change your SQL Statement to this

SELECT CODE
FROM TABLE1
WHERE CODE=NVL(:VCODE,CODE);

Regards
Ravi..

Report message to a moderator

Previous Topic: data and forms
Next Topic: how to format cells in Excel from Oracle Forms?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 12:19:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.