Dennis,

Trouble is, I cannot get rid of RecordCount because it is in the TDataset
class. I can only decide how to implement it.

By default matching the TQuery behavior exactly and providing a property to
flip for more client/server friendly behavior is all I can really do here.

So, in short, I am adding only two items:

property RecordCountAccurate: boolean;
function RecordCountQuery: longint;

if RecordCountAccurate is true then TDataset.RecordCount will return the
result of RecordCountQuery. If it is false it will continue using the
existing algorithm to make sure and detect if there is one and only one and
approximate the rest based on looking at the BufferRowCount and the
BufferHasEof and BufferHasBof properties.

Would you all prefer RecordCountQuery or RecordCountServer?

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com