Malformed SQL Pivot Query?
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
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
Comments