Page 1 of 1
how to handle the LOV
Posted: Thu Jul 06, 2006 7:40 am
by mfa786
hi master
first i very sorry for my last mail without rong subject
and
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
Posted: Thu Jul 06, 2006 8:21 am
by mirza_rehan
Confused question please write yours question again correctly
take care
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Thu Jul 06, 2006 9:31 am
by admin
You can use percentage sign (%) to get the result. Like 1% or %ABC. Hope it will work for you.thanks
Posted: Fri Jul 07, 2006 4:46 am
by mfa786
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
Posted: Fri Jul 07, 2006 5:13 am
by mirza_rehan
Where you want to type ??? in any field or on list of values????
please reply
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Sat Jul 08, 2006 1:28 am
by RiazAhmad
So simple, when u invoke LOV, if u want to search by first column then put your criteria before % sign in Lov Criteria text box and if you want to search by second column just put your criteria after % sign in LOV criteria text box.