I have some array with custom type fields, totally 10 fields:
Type Node(Name As String, Q As Int, p As Int, vcalc As Float, vreal As Float, tStart As Long, tEnd As Long, tEndCalc As Long, LogDist As Int, NodeType As String)
Then this is used to define array:
Dim Nodes(20) As Node
This works fine, but problem is when there is need for redim this array to more or less nodes. If I re-dim it again by using following command, all data in existing nodes are lost:
Dim Nodes(21) As Node
As I understand List's and Map's are better regarding dynamic re-dimensioning, but it can not hold data structure as above, or am I wrong?
Is it better to use DB for this use?
Type Node(Name As String, Q As Int, p As Int, vcalc As Float, vreal As Float, tStart As Long, tEnd As Long, tEndCalc As Long, LogDist As Int, NodeType As String)
Then this is used to define array:
Dim Nodes(20) As Node
This works fine, but problem is when there is need for redim this array to more or less nodes. If I re-dim it again by using following command, all data in existing nodes are lost:
Dim Nodes(21) As Node
As I understand List's and Map's are better regarding dynamic re-dimensioning, but it can not hold data structure as above, or am I wrong?
Is it better to use DB for this use?