prepared statement "PRSTMTSTxxxxxxxxx" does not exist

adroege · Post by **adroege** » Wed 01 Jun 2011 19:45

We are using Delphi 7 and UniDac version 3.60.0.16 and the PostgreSQL provider and are sometimes getting this error when we execute the following.

Query1.FetchRows:= 250;
Query1.SpecificOptions.Values['FetchAll']:= 'false';

//The wwDBGrid.DataSource.DataSet is Query1

//The error happens sometimes on the refresh
wwDBGrid.DataSource.DataSet.Refresh;

The error is:
prepared statement "PRSTMTSTxxxxxxxxx" does not exist

Can you please help? Thanks.

AlexP · Post by **AlexP** » Thu 02 Jun 2011 08:51

Hello,

We've already fixed a similar problem. Please download the latest UniDAC version (3.70.0.17) and try again.

adroege · Post by **adroege** » Thu 02 Jun 2011 12:15

After we posted the problem we have found that doing this:

Query1.Options.AutoPrepare:= true;

seems to make the error go away.

Is this a viable solution? Or does your latest fix improve the situation even beyond what we are able to see?

Thanks.

AlexP · Post by **AlexP** » Thu 02 Jun 2011 14:22

Hello,

In the latest version this problem is not reproduced with any AutoPrepare value. We recommend you to use the latest version of the product, because such problems are not always caused by the AutoPrepare value. In previous versions they may occur in different situations.