Change Array size durring runtime 2

[Japskunk72]

I want to be able to change the number of objects i have in an array based on how many fields i have in a table.

Module TBLInfo
Public PaStructTBLBackup(TBLBackupLocAMT) As structTBLBackLoc
Public Sub LoadDB()
Dim Amt As Integer
Dim X As Integer

DBConnect.Connect("Select * from TBLBackuploc")
Amt = RS.RecordCount
tblbackuplocAMT = AMT
For X = 1 To AMT
With PaStructTBLBackup(X)
.BackupLoc = RS.Fields "BackupToloc").Value
.FileName = RS.Fields("Filename").Value
End With
RS.MoveNext()
Next
RS.Close()
end sub
Public Structure structTBLBacloc
Dim BackLoc As String
Dim FileName As String
End Structure
End Module

is there a way to publicly declair an array and beable to change the array size durring the program?
Thanks
JT

 

[chrissie1]

redim is the word you are looking for and redim preserve to keep the values that were already there. but this isn't the ".net" way.

Lookup arralist and see that it is much better for what you want to do.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[chiph]

I would also suggest using an ArrayList over a regular array in this case.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[Japskunk72]

Thanks Chrissie1, I found this microsoft website that explains how to create an arraylist and use a structure. its not explianed that great in the MSDN descriptions for doing this...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;313638

Thanks again