OraFAQ Forum: Forms » how Handel the lov

Home » Developer & Programmer » Forms » how Handel the lov

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how Handel the lov [message #181016]

Thu, 06 July 2006 05:39

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master
sir i have lov with two column title and code

sir my user need he select the lov by both method
if is press a then lov display which record those start with a
if he press 1 then lov display which record those start with 1
means selection on both field on title and code
if he remember code or remember title

please give me idea how i get both type result

thank
aamir

Report message to a moderator

Re: how Handel the lov [message #181020 is a reply to message #181016]

Thu, 06 July 2006 06:15

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Do you mean that you have two separate fields? In that case create two LOV's based on the same record group. Since you can only filter on the first column in the LOV you need to change the order of the columns.
In the "CODE_LOV" code, title and in the "TITLE_LOV" you set the columns "title, code"

MHE

Report message to a moderator

Re: how Handel the lov [message #181151 is a reply to message #181020]

Fri, 07 July 2006 01:49

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

thank for your reply

no sir
i have only one lov and two colum one is numric and other one is title strint
user can select both by press numric or string

how

thank

Report message to a moderator

Re: how Handel the lov [message #181154 is a reply to message #181151]

Fri, 07 July 2006 01:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

No, he cannot. Use 2 separate LOVs. A LOV can only filter by the first column, whether you like it or not. Another option would be to create your own lookup screen but why make it hard if all you have to do is create a second LOV based on an existing record group?

MHE

Report message to a moderator

Re: sir see my problem [message #181168 is a reply to message #181020]

Fri, 07 July 2006 02:47

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

thank for your reply
sir i have this is lov query

SELECT CHARTOFACC.TITLE||' '||
CHARTOFACC.ACCID AS comcode FROM chartofacc;

and this is data or column

LAND K1101
BUILDING K1102
COMPUTERS / PRINTERS K1103
OVERHEAD PROJECTORS K1104
MULTIMEDIA K1105

Sir my question
Is where I % % put in my query user only press 1 number or abc string
And get result as per give starting word

thank
aamir

Report message to a moderator

Re: sir see my problem [message #182354 is a reply to message #181168]

Fri, 14 July 2006 07:55

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Please experiment with the various LOV proerties like auto select, and auto display.

David

Report message to a moderator

Previous Topic:	HOW TO SAVE XLS to CSV?
Next Topic:	HELP !!!! : How Set v$session.module in Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 11 08:21:23 CDT 2026