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
how to handle the LOV
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
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
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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Who is online
Users browsing this forum: No registered users and 1 guest