I need to loop through a document collection and store 7 field values form each document. I know that there will always be 7 fields, but the number of documents is determined at run time. I tried dim TestArray(1 To x, 1 To 7), but this throws an error. If I put a fixed number in place of variable x it work fine. I also need to sort the array on field 1 after reading the document collection.
Can this be done in LotusScript? Can anyone provide example code?