<div>
<div class="content wysiwyg-content">
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. &nbsp;I tried dim TestArray(1 To x, 1 To 7), but this throws an error. &nbsp;If I put a fixed number in place of variable x it work fine. &nbsp;I also need to sort the array on field 1 after reading the document collection.<br />
Can this be done in LotusScript? &nbsp;Can anyone provide example code?<br />
<br />
Thanks
</div>
</div>


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?

Thanks

Dynamic multi-dimension array in LotusScript

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.