i want to find the record in the LOV with any one of the field [message #177642] |
Thu, 15 June 2006 23:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ranisri321
Messages: 22 Registered: March 2006 Location: hyderabad
|
Junior Member |
|
|
hi
i have one fomr module in that i created a lov .the fields in the lov are(code,name,state,country).
i want to search the record in the lov withrespect to any one of the above mentioned fields not with only first column.
it is very urgent pls send me the replay as soon as possible
the query in the LOv is "select name,code,state,country from cuty order by name".
THE table fields are
CODE NOTNULL
NAME
STATE
COUNTRY
|
|
|
|