[RP2.40] SQL?
Posted: Mon Dec 23, 2024 5:08 pm
Just thought (...) i'd try changing a simple one table RP designer-report from dbf to sql.
Removed the link to the dbf, added a PG driver (from computer data sources), changed the fieldnames accordingly - see in the expression editor all the relevant tables and fields. No errors at save.
But when openining the preview i get:
The following error was encountered while reporting:
FEHLER: Syntaxfehler bei »..«;
Error while executing the query
Ahem. Anyone an idea what and how i might proceed?
(Just in case if you wonder, why i don't export the PG table to a tmp dbf - my DBMigration tool chokes writing PG to odbc, up to now i never saw the need to hunt that problem down..)
Anyway, i should know better than to undertake such ventures in this time of the year: Happy Christmas to all of you, peace and health!
Removed the link to the dbf, added a PG driver (from computer data sources), changed the fieldnames accordingly - see in the expression editor all the relevant tables and fields. No errors at save.
But when openining the preview i get:
The following error was encountered while reporting:
FEHLER: Syntaxfehler bei »..«;
Error while executing the query
Ahem. Anyone an idea what and how i might proceed?
(Just in case if you wonder, why i don't export the PG table to a tmp dbf - my DBMigration tool chokes writing PG to odbc, up to now i never saw the need to hunt that problem down..)
Anyway, i should know better than to undertake such ventures in this time of the year: Happy Christmas to all of you, peace and health!