Hi.. we are upgrading from 8.1 to 8.4. One of the reports, when I run the validate, gives me this error message:
QE-DEF-0469 QE Message
RQP-DEF-0258 The Order By command in nested SQL is not allowed.
I have removed all Order By's that I can possibly find in the Queries, but still I'm getting this error. Is anyone familiar with this?
The XML message gives this:
<message severity="warning"title="QE-DEF-0469 QE Message"type="general">RQP-DEF-0258 The Order By command in nested SQL is not allowed.
</message>
Thanks for any help!
Hi Cynthia,
Sorry - more details are required, I'm afraid. How is the report constructed? Is it a single query, or multiple queries joined/unioned/linked via Master-Detail, or...? Does the report use hard-coded SQL?
MF.
Oh boy... hard questions! :) I am not quite that advanced.... but I'll try. We don't have any hard coded SQL... it's only what the report builds on it's own.
I think there are multiple queries but they were built for prompts. Hrm... we might just rebuild the package and see if that helps. :)
Hi,
One thing you could try is to go to Query explorer, go into each query in turn, then go to Run -> View Tabular Data. You may find the error is coming from just one particular query, which will help narrow things down a bit.
MF.