Re: Query load every row

From: Arnie Mauer (xxx_at_nowhere.net)
Date: 12/05/03 

Date: Fri, 5 Dec 2003 11:29:25 -0500

"Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
news:cktvsv4lhbva2ad8119vq2qrbtmi2t50cj@4ax.com...
> >I was surprised to notice that the query using ado loads every possible
row
> >(even if there are a lot more than 50000 rows answered to the question).
> >That was not the case with query using BDE.
> >Is there something that manages this behaviour?
>
> You have a few choices. If you user a clientside cursor ADO will fetch
all
> records unless you specify a MaxRecords property. Maxrecords works for a
limit
> but ADO does not have a way to fetch the next group of records so it is
kind of
> limited.
> When I design an interface where the user can enter any selection criteria
I
> will often se MaxRecords and the warn the user if the criteria they enter
> returns maxrecords that they should further limit their query.
>
> You can set the ExecuteOptons for an eoAsyncFetch and records will be
fetched in
> the background after the initial fetch. This does not work with a grid
>
> You can use a clientSide which doesn't fetch records but is an open cursor
on
> the database
>
>
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Didn't you mean a server-side cursor?

- Arnie

Relevant Pages

  • Re: Query load every row
    ... >That was not the case with query using BDE. ... If you user a clientside cursor ADO will fetch all ... records unless you specify a MaxRecords property. ...
    (borland.public.delphi.database.ado)
  • Re: Query load every row
    ... My issue is relative to the use with a grid that I supposed that fetch only ... have replaced them by ADO) ... > records unless you specify a MaxRecords property. ...
    (borland.public.delphi.database.ado)
  • RE: ODBC query in VB code Need HELP
    ... Everything for ADO is in the first 2 messages that I gave you. ... Since your pass-through query already exists (including the ... Dim STRSQL As String ...
    (microsoft.public.access.formscoding)
  • Re: Connecting to Query
    ... practice examples of the ADO Command, Parameters, etc. you explained below. ... Second, with the selected territory ... >> combo box to select a product from a query based primarily on a link ...
    (microsoft.public.access.formscoding)
  • Re: On ADSI and LDAP
    ... the problem is how can I retrieve the value for myuser using the ... would be more efficient to use ADO to query AD for the attributes values. ... For more on using ADO, ... Dim adoCommand, adoConnection, strBase, strFilter, strAttributes ...
    (microsoft.public.scripting.vbscript)