Devart Forums

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.

Hello,

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

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.

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.