Devart Forums

Hello,

I plan to port an application to PgDac.
I need to execute multiple SQL statements for updating my database.
So I fill the SQLUpdate property of my TPgQuery.

And I get the following exception:
'cannot insert multiple commands into a prepared statement'

I tried to set UnpreparedExecute to True.
But UnpreparedExecute only affects SQL property (not SQLUpdate, SQLInsert...).

My code works when I use ProtocoleVersion pv20, but I really want to use pv30.

Do you have any suggestion ?
Thanks

This is a bug. We'll add a fix in the next PgDAC build. The UnpreparedExecute option will affect the update SQLs.