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.

03-21-2008, 08:54 AM	#1 (permalink) dynamic array using info from DB
ChipJohns I don't know! Do you? Posts: 477 Name: Chip Johns Location: Savannah Georgia Talkupation:	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

03-21-2008, 12:23 PM	#2 (permalink) Re: dynamic array using info from DB
chrishirst Super Moderator Posts: 10,594 Location: Blackpool. UK Talkupation:	objRs.GetRows() __________________ Chris. ->> Links are advertising NOT optimising!! <<- Indifference will be the downfall of mankind, but who cares? Code Samples \| People Counting System

03-21-2008, 03:01 PM	#4 (permalink) Re: dynamic array using info from DB
Learning Newbie Moderator Latest Blog Post: My Favorite Isaac Asimov Story Posts: 4,068 Name: John Alexander Talkupation:	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. __________________ HungarianNotation is the last resort of scoundrels. Why not the first resort? That's where it counts!

03-21-2008, 01:17 PM	#3 (permalink) Re: dynamic array using info from DB
ChipJohns I don't know! Do you? Posts: 477 Name: Chip Johns Location: Savannah Georgia Talkupation:	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!!

03-25-2008, 03:51 PM	#5 (permalink) Re: dynamic array using info from DB
ChipJohns I don't know! Do you? Posts: 477 Name: Chip Johns Location: Savannah Georgia Talkupation:	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...

03-27-2008, 04:42 AM	#6 (permalink) Re: dynamic array using info from DB
Azazel28 Novice Talker Posts: 9 Talkupation:	Thats guys I was looking at a very similar issue.