Re: EOAsyncFetchNonBlocking Question

Paul,

This is the solution I've found while googling, it seems to be a known bug.
Just place this code inside the OnAfterScroll event of TADOQuery.

if DataSet.Bof or DataSet.Eof then
begin
DataSet.DisableControls ;
with TCustomADODataSet ( DataSet ) do
begin
if Bof then
Recordset.MoveFirst
else
if Eof then
Recordset.MoveLast ;
CursorPosChanged ;
Resync ( [ ] ) ;
end ;
DataSet.EnableControls ;
end ;


Randy.

"Paul Scott" <paul.scott@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:op.ua6zq0mjjpqj2l@xxxxxxxxxxxxxxxxxxxxxxxx
Randy,

On Thu, 15 May 2008 08:39:27 +0100, Randy Adanza <radanza@xxxxxxxxxxx>
wrote:
Then I found out that by setting TADOQuery.ExecuteOption to
EOAsyncFetchNonBlocking speeds up things quite nicely. However, I found
out that it seems to bypass the First and
Last record, I did however found a fix for that.

Would you care to share your solution?

--
Paul Scott
Information Management Systems
Macclesfield, UK.


.

Relevant Pages

  • Re: Redistributing VS2008 MFC app?
    ... |> I did some googling and found a known bug. ... The suggestion was to DL ... |Download and install Virtual CloneDrive which allows you to mount iso files ...
    (microsoft.public.vc.language)
  • Re: Great Looking Heat Sinks
    ... Anssi Saari wrote: ... After some Googling, it's a bug which Microsoft apparently ... for unlike the custom chips and replacing ...
    (comp.sys.cbm)
  • Re: Repositioning a field corrupts DBGrid !!!
    ... because both TAdoQuery and TAdoStoredProc ... are decendants of TAdoCustomDataSet. ... The bug surfaces itself quite randomly. ...
    (borland.public.delphi.database.ado)
  • Re: dpkg EOF mozilla error after dselect install
    ... Nick Lidakis wrote: ... Googling only works if something's been around long enough for them ... its bug list. ... Bingo, lots of bugs already filed about this, and the ...
    (Debian-User)
  • Re: Great Looking Heat Sinks
    ... Anssi Saari wrote: ... After some Googling, it's a bug which Microsoft apparently ... never got around to fixing in OE. ...
    (comp.sys.cbm)