Multiple SQL statements in SQLInsert/SQLUpdate...

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
syagrius
Posts: 10
Joined: Sat 28 Feb 2009 13:45

Multiple SQL statements in SQLInsert/SQLUpdate...

Post by syagrius » Tue 17 Mar 2009 15:21

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

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 19 Mar 2009 08:59

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

Post Reply