Home » Developer & Programmer » Reports & Discoverer » Unable to parse query (reports developer 2000)
Unable to parse query [message #395425] Wed, 01 April 2009 07:24 Go to next message
privs
Messages: 11
Registered: February 2009
Location: South Africa
Junior Member

Can anyone help me, i wrote a report code and it works in version 6i but when i put that query in ver 4.5 it gives a REP-0496: Internal Error - Unable to parse the query

Can anyone help me

I nclude the query for your perusal
Re: Unable to parse query [message #395428 is a reply to message #395425] Wed, 01 April 2009 07:39 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
I imagine version 4.5 doesn't recognize ANSI SQL.
Re: Unable to parse query [message #395430 is a reply to message #395428] Wed, 01 April 2009 07:43 Go to previous messageGo to next message
privs
Messages: 11
Registered: February 2009
Location: South Africa
Junior Member

is there any way i can overcome this problem?
Re: Unable to parse query [message #395449 is a reply to message #395425] Wed, 01 April 2009 08:26 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't use version 4.5 - it's been desupported for years.

Otherwise you're going to have to rewrite your sql to non-ansi syntax.
Re: Unable to parse query [message #395451 is a reply to message #395449] Wed, 01 April 2009 08:31 Go to previous messageGo to next message
privs
Messages: 11
Registered: February 2009
Location: South Africa
Junior Member

but i have to do it in 4.5 also so sad for me Sad
Re: Unable to parse query [message #395500 is a reply to message #395451] Wed, 01 April 2009 12:06 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So use 4.5 version - just rewrite the query!

In other words (and as an example), instead of
SELECT e.ename, d.dname
FROM EMP e left join DEPT d
ON e.deptno = d.deptno
you'd have
SELECT e.ename, d.dname
FROM EMP e, DEPT d
WHERE e.deptno = d.deptno

[Updated on: Wed, 01 April 2009 12:09]

Report message to a moderator

Re: Unable to parse query [message #395611 is a reply to message #395500] Thu, 02 April 2009 01:14 Go to previous messageGo to next message
privs
Messages: 11
Registered: February 2009
Location: South Africa
Junior Member

Thanks, I'll try to uncomplicate my query (bearing in mind I'm still new at SQL Smile )
Re: Unable to parse query [message #395688 is a reply to message #395425] Thu, 02 April 2009 04:48 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Another trick you can try is create a view based on your query then query that in the report.
reports 4.5 might not know ANSI sql but it should know views (I'm guessing - never used that version).
Re: Unable to parse query [message #395692 is a reply to message #395688] Thu, 02 April 2009 05:02 Go to previous message
privs
Messages: 11
Registered: February 2009
Location: South Africa
Junior Member

I will try that. thanks . If that wot work, I may just split it into8 separate queries then use it that way in the report as 8 different groups


Thanks
Previous Topic: Error While Generating Report REP-00999 Unimplemented Error
Next Topic: Error while exporting Data from discoverer viewer
Goto Forum:
  


Current Time: Fri Dec 02 23:11:08 CST 2016

Total time taken to generate the page: 0.17483 seconds