skintpaul
asked on
moving the columnvalues array into a VB array
Hi folks
I'm writing a VB app that loops through the documents in a Notes view as follows and moves the values in the view into a variant array using .ColumnValues
While Not oDoc Is Nothing
Dim s() As Variant
s = oDoc.columnvalues
'manipulate s here
Wend
However when it comes across views that contain saved conflict documents it does bizarre things like creating a 2d array for certain fields
ie. my array s when there is no conflicts
s(0) = "blah"
s(1) = "blah"
s(2) = "blah"
s(3) = "blah"
with conflicts it might load up my variant array as follows
s(0) = "blah"
s(1) = "blah"
s(2)
s(2)(0) = "blah"
s(3) = "blah"
I however dont know how to handle this as, if I refer to s(2)(0) each time, then my program will crash when it doesnt have a value ?
and s(2) on this occasion doesnt have a value
I hope this makes sense
Any help appreciated
Paul
I'm writing a VB app that loops through the documents in a Notes view as follows and moves the values in the view into a variant array using .ColumnValues
While Not oDoc Is Nothing
Dim s() As Variant
s = oDoc.columnvalues
'manipulate s here
Wend
However when it comes across views that contain saved conflict documents it does bizarre things like creating a 2d array for certain fields
ie. my array s when there is no conflicts
s(0) = "blah"
s(1) = "blah"
s(2) = "blah"
s(3) = "blah"
with conflicts it might load up my variant array as follows
s(0) = "blah"
s(1) = "blah"
s(2)
s(2)(0) = "blah"
s(3) = "blah"
I however dont know how to handle this as, if I refer to s(2)(0) each time, then my program will crash when it doesnt have a value ?
and s(2) on this occasion doesnt have a value
I hope this makes sense
Any help appreciated
Paul
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please post your relevent code.
ASKER
Folks
I found the answer. I'm going to use ISarray(s(x)) to determine how to handle each item of the array.
Thanks for your efforts. I have another question that I'm about to post regarding Notes View Column names
Paul
I found the answer. I'm going to use ISarray(s(x)) to determine how to handle each item of the array.
Thanks for your efforts. I have another question that I'm about to post regarding Notes View Column names
Paul
Actually, that's the way it is handled in LotusScript as well.