Home » Developer & Programmer » Forms » LOVS
LOVS [message #384228] Mon, 02 February 2009 23:21 Go to next message
tipyyt
Messages: 11
Registered: March 2007
Location: Karachi
Junior Member

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 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered using the 'long form' on the default LOV?

David
Previous Topic: Problem with webutil
Next Topic: passing a value at runtime
Goto Forum:
  


Current Time: Fri Dec 09 23:37:17 CST 2016

Total time taken to generate the page: 0.04869 seconds