Traci Sumpter wrote:
> have you tried RefreshRecord??

Yes, RefreshRecord retrieves the entire query, I should look at the code but I suspect the TClientDataSet.RefreshRecord passes the request to the TDataSetProvider which opens the entire TQuery, locates the record then sends that record back up to the TClientDataSet.

Does anyone know how to stop this behaviour of opening the entire TQuery and instead getting only the one record

Eg somehow changing
select * from contact
to
select * from contact where code = 1234

or something like that

Alister

---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Reply via email to