Another option to the function in NotesDatabase was to use the FTSearch() method in NotesView but this method behaves different depending on whether the database is full-text indexed or not. Apparently the sorting of the view is only honored for the search results if the database is NOT full-text indexed. Why this distinction? Why not give me the option?
Anyways… The solution was to use the FTSearch() method in NotesDatabase as I started out doing and then using a function I found via Lotus Developer Domain that can sort a NotesDocumentCollection based on field names.
The function is written by Max Flodén and is available from http://www.tjitjing.com.
I think that a SortedDocumentCollection object is one of those things that just about every serious LotusScript programmer either writes or downloads at some point. Over the years I’ve written several versions, and borrowed several more 🙂