I'm trying to get certain record into an array like this.
rsTemp.Open "Select * From list Where pid = " & iItemID
If Not rsTemp.EOF Then
aParameters = Array(
GetItemParameters = aParameters
And then when I call the aParameters, I'm getting this error
Type mismatch: 'aParameters'
So, I think I'm having syntax problem with the array. I know that it would work if I put in
aParameters = Array("1","2","3")
I think it's not working because I'm missing the quotation mark but then it wouldn't understand that it's a record and not text. What's the right syntax to use here?