Using bookmarks causes recordset to lose knowledge of its Max records?

[George Hester]

Anyone know why this is and what can be done about it. Here is how I am
doing it for a Recordset (ADO) rt.

Set rtClone = rt.Clone
'I put rtClone to the record I want. How that is done wouldn't make sense
here but this is it
rtClone.Move v((i + 1)), 1
sBookmark = rtClone.Bookmark
rt.Bookmark = sBookmark

That's it. When the recordset rt goes to the bookmark it loses its
maxrecordcount. It becomes -1. This is ADO 2.7 in a DAP Access 2000.

 

[kalidou]

slut ravie de vous connaitre

 

[a a r o n . k e m p f]

are you using the clientside cursor?

and I really don't understand what you're trying to do. I usually just
FILTER for the one record I want to display, you know?

-Aaron

 

[George Hester]

Hi there. What happened is I was closing the rtClone and shouldn't have
been. The call to rtClone happens a few times and I thought I could close it
right after using it. But that caused the RecordCount to go haywire. Anyway
I took those close statements out and it was okay after. I don't use filter
because the Grid gets destroyed when I use a Server filter and so I have
been using a diferent way to get to the records I want. What you saw with
the bookmark was just one of the ways.