Multiples commands.

Multiples commands.

Postby 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???
Posts: 25
Joined: Tue 17 Mar 2009 12:47

Postby 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.
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Return to dbExpress driver for PostgreSQL