dynamic array using info from DB

**ChipJohns** · 03-21-2008, 08:54 AM

What am I missing?

I think I have the logic of what I want to accomplish.. Just can't get a handle on if this is the right way. I want to take info from a db table and populate an array with it..

Here is what I have...

Code:

i=0 
Dim myinfo()
While Not ObjRS.EOF 
myinfo(i) = objRS("ppBAPNO")
i=i+1
objRS.MoveNext
Wend
objRS.Close
objConn.Close

**chrishirst** · 03-21-2008, 12:23 PM

objRs.GetRows()

**ChipJohns** · 03-21-2008, 01:17 PM

Is it really that easy....?

I'll let you know how I make out with it..

Thanks,

Chip

p.s. I did look on w3schools.! It is a little easier to find the info when you know 'what-the-flip' your looking for... You make it look easy Chris. Really P's me off...

Thanks man!!

**Learning Newbie** · 03-21-2008, 03:01 PM

I think your first code is right, from what I've seen of that, but how do you dim the array? My guess is it's running out of slots? You can use REDIM PRESERVE but I think Chris's method is much better.

**ChipJohns** · 03-25-2008, 03:51 PM

Getting bogged down with other things and will get back to this. Thanks... I will let you know when I get back to it... Me and the other person I work with are in charge of 54 projects. It is insane...

**Azazel28** · 03-27-2008, 04:42 AM

Thats guys I was looking at a very similar issue.