| lov/err [message #82626] |
Fri, 13 June 2003 13:33  |
jels
Messages: 29
Registered: April 2003
|
Junior Member |
|
|
when i wrote this query in lov wizard
select client_no,name INTO :client_no, :client_name from client_master;
it displaying the error
frm-10902 invalid sql query
when i selected the query builder i selected 2 colums
but the lov is not working and displaying also
how diaplay it i put x,y psotion but no result
SELECT ALL CLIENT_MASTER.CLIENT_NO, CLIENT_MASTER.NAME
FROM CLIENT_MASTER
pls hlp
|
|
|
|
| Re: lov/err [message #82638 is a reply to message #82626] |
Mon, 16 June 2003 00:44  |
Sun
Messages: 92
Registered: August 2002
|
Member |
|
|
SELECT ALL CLIENT_MASTER.CLIENT_NO, CLIENT_MASTER.NAME
FROM CLIENT_MASTER
When ever u face some problem u check the same query what u have written in Sql. Check whether it is working or not...
What is the ALL...?? I think it is creating problem. Check your query..
Sun
|
|
|
|
| Re: lov/err [message #83199 is a reply to message #82626] |
Thu, 21 August 2003 00:12 |
prashant
Messages: 122
Registered: September 2000
|
Senior Member |
|
|
I hope you have created the fields
:client_no, :client_name
in ur form. Try this query in SQL.
Ta
Prashant
|
|
|
|
|
|
|
|
|
|
| Re: lov/err [message #656375 is a reply to message #656374] |
Tue, 04 October 2016 10:29 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I don't think that semi-colon is a culprit. I'd put my bet on OP's lack of knowledge, as it seems that he tries to create a LoV the way he *thinks* it should be done, instead of following the rules. A LoV query certainly doesn't contain INTO, it has nothing to do with "x and y position". The simplest way is to create a Record Group query, then create a LoV based on that Record Group, follow the Wizard (that's why it is here) without taking shortcuts, properly map LoV columns with form items and ... well, everything should be fine.
Anyway, this is a useless discussion, just like a skeleton in a closet.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
