The problem is idenitied, it's not related to the case originally described. After TZQuery SQL text is changed, parameters assigned to the previous SQL are partially unchanged, i.e. parameter names are set to new SQL, but data types are unmodified !
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Complier is Delphi 10.1 Berlin update 2
Postgres - got same problems with 12.5 and 11.1
The problem is idenitied, it's not related to the case originally described. After TZQuery SQL text is changed, parameters assigned to the previous SQL are partially unchanged, i.e. parameter names are set to new SQL, but data types are unmodified !
and values also kept wrong
Please update from trunk (SVN).
Patch done r7234
Regards, Michael
Rsolved already.