Multiples commands.

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Posts: 25
Joined: Tue 17 Mar 2009 12:47

Multiples commands.

Post by Claudio » Mon 06 Apr 2009 20:43

I do not manage to execute multiples commands in a SQL.
update xxxxx;
update xxxxx;

Is this a BUG???

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

Post by Plash » Thu 16 Apr 2009 09:22

This not a bug. The driver prepares statement before executing it. PostgreSQL allows to have only one statement in the SQL text when PostgreSQL prepares SQL.

In the next build of the driver we'll add UnpreparedExecute extended driver option. If you set it to True, the driver uses simple query execution without preparation. So that you can add several statements to the SQL property.

Post Reply