Page 1 of 1

Differenz between

Posted: Mon 15 Jun 2009 21:16
by dschuch
Hy,

what is the differenz between

Options.AutoPrepare; (thats clear and described in the help)
AND
Options.UnpreparedExecute;

?

Posted: Tue 16 Jun 2009 08:18
by Plash
When UnpreparedExecute = True, the query is executed in "simple execution" mode. This allows to add several statements separtated by semicolon to the query text. But, real parameters are not supported in this mode. PgDAC emulates the parameters support by embedding the parameter values into the query text.

The AutoPrepare option is not related to UnpreparedExecute. If you set AutoPrepare to True, PgDAC calls the Prepare method automatically when you call Open or Execute, and the query remains prepared until you call the UnPrepare method.