Thread: help me please
View Single Post
  #8 (permalink)  
Old April 4th, 2006, 12:58 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi hastikeyvan,

I am not sure if I like the idea of working with arrays of recordsets like this. Recordsets can consume a lot of memory, and holding 11 of them in memory at the same time, is asking for troubles.

That said, I think the key to your problem is the Set keyword again. I haven't tried it, but I don't think you can use array(i).MoveNext like that. You may need to assign it to a local variable first:
Code:
Dim localRecordset
For i = 0 To 10
  Set localRecordset = Array(i)
  localRecordset.MoveFirst()
  While Not localRecordset.Eof
    bla bla bla
  Wend
Next
Also, I wouldn't be surprised if Array is a reserved word, so hopefully you're using a different variable name.

Hope this helps,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: Subculture by New Order (Track 8 from the album: Substance - Disc 1) What's This?
Reply With Quote