🚀 go-pugleaf

On Wed, 26 Dec 2001 12:37:17 -0500, "CR Hinners" <chinners@home.com> wrote:

>I saw many posts in delphi.database.ado on an issue with ADO Express
>and MDAC 2.6, where after canceling an edit and closing the data set,
>an "Either BOF/EOF is true" error is received, even with ADO Express
>Update 1 installed. The solution was to install the Delphi ADO Express
>Update 2. Is this update on the way for BCB?
Uhm..., AFAIK, only "ADO Express Update 1" exists for BCB.

>I get this error when using the SQL Server driver, with MDAC 2.7, and
>a TQuery server-side, dynamic cursor, but not if the cursor is changed
>to keyset. 
Even after you have installed the aforesaid patch?

>I also noticed that, using the DB navigator with the
>dynamic cursor, one can click the "Next" button beyond the last record
>to a blank (EOF?) record before the "Next" button is disabled. Again,
>this doesn't occur with a keyset cursor.
That behavior is normal if you are using server side cursor. When you are
using client side cursors (like the keyset cursor, I suppose), you can count
on the fact you have the entire recorsed (the relation) loaded in memory, so
you don't need for further information from the DBMS about data boundaries:
navigators (and scrollbars, and others data-aware controls) they can take
advantage of that fact in order to make the user's interaction much more
comfortable.

Ciao

Giuliano