Zeoslib Portal

Hello,

1- PostgreSQL does not allow multiple statements if it is prepared.
2- PostgreSQL can work with multiple statements executed as they are.

I need to use multiple statements in TZQuery. I get all statements prepared even if I have doPreferPrepared set to False. Is it possible to tell TZQuery not to prepare the statements?

Thanks.

Ertan

Why do not you use ZSQLProcessor?

Michal

No particular reason, I just saw the option and tried to use TZQuery.

Ertan

Hello Ertan,

currently there is no option to do that. You possibly can achieve it by modifying ZDbcPostfgreSQL.pas. Make sure that CreateRegularStatement and CreatePreparedStatement return a TZPostgreSQLClassicPreparedStatement instead of a TZPostgreSQLCAPIPreparedStatement.

With best regards,

Jan