| LOVS [message #384228] |
Mon, 02 February 2009 23:21  |
|
|
When I wrote this query on SQL
SQL> select NAME FROM CU_CUSTOMER
2 WHERE NAME LIKE('&A%')
3 /
Enter value for a: DAN
old 2: WHERE NAME LIKE('&A%')
new 2: WHERE NAME LIKE('DAN%')
NAME
--------------------------------------------------
DANYIAL AHMED SHEIKH
DANISH ZAHOOR
Now i want this query in my lov.My field name is <NAME>.My requirment is this LOV only select those name ,which are like the name entered.,
when in wrote this query in record group
select NAME FROM CU_CUSTOMER
2 WHERE NAME LIKE(':name%')
In <NAME> field I typed DAN as i did on SQL
I call my LOV on when-mouse-double-click trigger on item <NAME>,
WHY I AM RECEIVING THIS MESSAGE, *LOV CONTAINS NO ENTRIES*
Regards
Danish Hayder
[EDITED by LF: fixed [code] tags]
[Updated on: Tue, 03 February 2009 05:58] by Moderator Report message to a moderator |
|
|
|
| Re: LOVS [message #384291 is a reply to message #384228] |
Tue, 03 February 2009 03:02  |
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Anything in quotes is assumed to be a string not an item.
Try this:
select NAME FROM CU_CUSTOMER
WHERE NAME LIKE :name||'%'
|
|
|
|
| Re: LOVS [message #384459 is a reply to message #384228] |
Tue, 03 February 2009 23:22 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Have you considered using the 'long form' on the default LOV?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
