Malformed SQL Pivot Query?

Monte Carver

FR Gurus,

I have a rather complicated PIVOT Oracle query that I set dynamically to the SQL parameter of a FireDAC query dataset. In FR design mode, this query rendered as expected. But at run time it complains with the following error:

"[FireDAC][Phys][Ora] ORA-00923: FROM keyword not found where expected."

Some direction please as to what might be occurring? My guess is that FastReports is somehow modifying the query at runtime.

Regards,
Monte Carver

Delphi Seattle
FR 5.6.4

gpi

wrote:

My guess is that FastReports is somehow modifying the query at runtime

Or your code modify query at runtime