I've found question on SO:
http://stackoverflow.com/questions/4711 ... tch-lookup
and the answer:
Does something changed from then (2y ago)?Hello,
Now PgDAC can't use server-side cursor as you want. We will investigate the possibility of adding this feature in one of the next builds/versions of PgDAC.
Best regards, Alex Devart Team www.devart.com
I need it because of heavily usage of Table.SetRange/FindKey/Locate in our current application.
Without it, opening table fetch all rows. I know that I can set FetchAll=False, but if I make FindKey (with for example last record), then it loads whole table into client app memory. Same with Table.Append, loads whole table.
Also I'm aware of FilterSQL property, but it would require a lot of re-factoring.