RefreshRecord Slow

Claudio · Post by **Claudio** » Thu 10 Jun 2010 17:52

DLL Version: 1.10.0.8

Delphi 2010.

Parameters;

HostName=localhost
DataBase=test
DriverName=DevartPostgreSQL
User_Name=postgres
OIDAsLargeObject=True
DetectParamTypes =True
UseUnicode=True

When I give a RefreshRecord it loads all the data first, and only after the selected record, I saw on the monitor.

Please investigate.

Thanks.

bork · Post by **bork** » Fri 11 Jun 2010 11:23

Hello

Please provide the following information: is your TSQLQuery or TSQLTable open before calling the RefreshRecord method or not.

Claudio · Post by **Claudio** » Fri 11 Jun 2010 16:09

Hi,

I'm using TSimpleDataSet.

Thanks.

bork · Post by **bork** » Mon 14 Jun 2010 09:41

Try to set the TSimpleDataSet.DataSet.Active property to True. In this case TSimpleDataSet will not reopen internal dataset on each RefreshRecord.