Re: compare 2 recordsets

I did say at the beginning that there are 2 different recordsets.
The one to manipulate (delete records) is an ordinary ADO client side recordset, disconnected.
The one to compare with is a dhSQLite recordset. Nil to delete in that one.

RBS


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message news:e3L$gjrAIHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • 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: ERROR with command text
    ... I'm not sure why you would think I would hate it. ... unnecessary recordset object when your run a query that returns no records ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: compare 2 recordsets
    ... doesn't have the filter method. ... It's a client-side ADO recordset isn't it? ... If not, I'm wasting my time ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: What to use for ADO parameter type and size
    ... Yes, leaving off the Set was a typo, but it worked fine tough. ... I think I do need the recordset as I need to move the data to a SQLite ... Maybe a nanosecond faster. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)