Home » Developer & Programmer » Forms » lov/err
lov/err [message #82626] Fri, 13 June 2003 13:33 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #656371 is a reply to message #82626] Tue, 04 October 2016 08:42 Go to previous messageGo to next message
mutopein
Messages: 1
Registered: October 2016
Junior Member
remove the ';'. It will be fine ! Cool
Re: lov/err [message #656372 is a reply to message #656371] Tue, 04 October 2016 08:46 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
You know this was a 13 year old thread right?
Re: lov/err [message #656374 is a reply to message #656372] Tue, 04 October 2016 09:39 Go to previous messageGo to next message
Michel Cadot
Messages: 67889
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It is never too late to do the right thing. Cool

Re: lov/err [message #656375 is a reply to message #656374] Tue, 04 October 2016 10:29 Go to previous message
Littlefoot
Messages: 21678
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.
Previous Topic: Unable to install Oracle Forms and Reports 12c
Next Topic: Unable to call Oracle report from Forms
Goto Forum:
  


Current Time: Fri Jun 25 05:42:57 CDT 2021