Stubborn Array won't Populate from single ADODB.Connection Query
Sorry Joel, this didn't work either. Its not a valid property.
On Aug 25, 1:31*am, Joel wrote:
You need to use a movenext. *I still think you should fix your DQL like I
recommended last time so you don't have to loop 5 times. *It significantly
slows down the code.
* *Let SQLquery = QueryUserInfo(x) 'Define source query
* *Set RecSet = Conn.Execute(SQLquery, , 1) 'Retrieve query value
* *Do until RecSet.Eof
* * * *For x = 0 To 5
* * * * * *Let SQLquery = QueryUserInfo(x) 'Define source query
* * * * * *Set RecSet = Conn.Execute(SQLquery, , 1) 'Retrieve query value
* * * * * *Let UserInfo(x) = RecSet.Fields.Item(0).Value 'Populate value
into field
* * * *Next x
* * * *RecSet.MobeNext
* *Loop
|