Guys,
Is it possible to pass an array that has been declared in one procedure to another procedure as a parameter and allow the second procedure to modify some of the array fields.
eg.
Sub Procedure1
Dim myArray
.
.
myArray = recordset.GetRows
Call Procedure2(myArray)
End Sub
Sub Procedure2(inpArray)
Dim i
For i = 0 to UBound(inpArray, 2)
if inpArray(5, i) = date() then
inpArray(4, i) = inpArray(4, i) + 10
end if
Next
End Sub Mise Le Meas,
Mighty
Is it possible to pass an array that has been declared in one procedure to another procedure as a parameter and allow the second procedure to modify some of the array fields.
eg.
Sub Procedure1
Dim myArray
.
.
myArray = recordset.GetRows
Call Procedure2(myArray)
End Sub
Sub Procedure2(inpArray)
Dim i
For i = 0 to UBound(inpArray, 2)
if inpArray(5, i) = date() then
inpArray(4, i) = inpArray(4, i) + 10
end if
Next
End Sub Mise Le Meas,
Mighty