Thread: help me please
View Single Post
  #7 (permalink)  
Old April 3rd, 2006, 11:59 PM
hastikeyvan hastikeyvan is offline
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

Hello Imar
The problem has been changed.thats the way i did:
1-create 11 recordsets(manually not dynamically)
2-set recordsets in an array:
Dim Array(11)
set Array(0)=rs
.
.
.
set Array(10)=rs10

3-set connection=nothing
4-write a for loop for looping through 11 recordsets:
for i=0 to 10
Array(i).movefirst()
while not Array(i).eof
bla bla bla
wend
next
but it gives me eof or bof error and i test my recordsets in SQL they are not empty
i'm really confused:(how can i fix it:(please help me as before
thank you Imar and excuse me if i ask such questions


Reply With Quote