Re: compare 2 recordsets

RB Smissaert wrote:
That looks logical, but a problem is that rsParentNode is dhSQLite
recordset, which
doesn't have the filter method.

Huh?? It's a client-side ADO recordset isn't it? If not, I'm wasting my time
here.
Oh wait ... that's why the FindNext method didn't look familiar: I assumed
it was a typo.

Yes, noticed that cursors (I take it
that this is MoveNext
etc.) are a bit slow.
Will try some other options.

What I meant say with Seek was that it might be slower than a
self-made loop as it will
keep seeking till EOF, even if it has no chance to find anymore. Does
this makes sense?

Yes. if the provider supports it, you can index the recordset so that Seek
will be very efficient. I don't know if that dhSQLite thingy supports that.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: compare 2 recordsets
    ... That looks logical, but a problem is that rsParentNode is dhSQLite recordset, which ... doesn't have the filter method. ... noticed that cursors (I take it that this is MoveNext ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: ADO FILTER property
    ... > I'm writing a reusable control that populates a listview with any ... Any recordset? ... > Is there a way i can treat all the fields as text fields in FILTER method? ... I wish the documentation was improved for all of these properties/methods. ...
    (microsoft.public.data.ado)
  • Re: compare 2 recordsets
    ... The one to manipulate is an ordinary ADO client side recordset, ... The one to compare with is a dhSQLite recordset. ... doesn't have the filter method. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: How to search
    ... There's the Find method of the Recordset ... and the Filter method (which can handle multiple columns). ... usually best to have the back-end database do the lookup as you illustrated ...
    (microsoft.public.vb.general.discussion)
  • Re: Wanna any idea to generate an ID
    ... a recordset with a pessimistic lock (this is pretty much the ... ASP) can be used to retrieve and increment the value: ... CREATE TABLE NextID ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)