ADO recordset problem in recursive routine
- From: "Mark" <mark@xxxxxxxxxx>
- Date: Tue, 24 May 2005 19:26:12 GMT
Hi
I'm converting some code which uses DAO to ADO. Basically it's a very simple
recursive routine (written in VBA) that works its way through a self
referencing table (with any number of levels - parent child etc.) in order
to populate a tree control.
In the original (DAO) version there are two recordsets, one containing all
the records (rsAll) and another containing the children of the current rsAll
record (rsChildren). This works just fine and is pretty fast...
Problem is I have used exactly the same technique in ADO but the rsChildren
seems to be permanently bound to the rsAll so when the recursion reaches a
level where there are no children it stops as rsAll (filtered) has zero
records, so when returning to the previous call the cursor is effectively at
the end of the recordset, which now has a count of zero too :@(
Any one know whats going on?
I can post some code if necessary, t's on another machine, but I got a
feeling there's no need as I'm probably just trying to do something thats
not possible in ADO...
Cheers
Mark
.
- Follow-Ups:
- Prev by Date: Re: SP4 MDAC NTVDM Error
- Next by Date: Re: ADO recordset problem in recursive routine
- Previous by thread: SP4 MDAC NTVDM Error
- Next by thread: Re: ADO recordset problem in recursive routine
- Index(es):
Relevant Pages
|
|
