Page 1 of 1

RefreshRecord Slow

Posted: Thu 10 Jun 2010 17:52
by Claudio
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.

Posted: Fri 11 Jun 2010 11:23
by bork
Hello

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

Posted: Fri 11 Jun 2010 16:09
by Claudio
Hi,

I'm using TSimpleDataSet.

Thanks.

Posted: Mon 14 Jun 2010 09:41
by bork
Try to set the TSimpleDataSet.DataSet.Active property to True. In this case TSimpleDataSet will not reopen internal dataset on each RefreshRecord.