in reply to Re^3: Lotus Notes date ranges not returning all documents
in thread Lotus Notes date ranges not returning all documents
Ahh, I do have an issue with the NotesSQL. The requirement that started this was to find all documents after a certain date that had a certain field empty. The field was a rich text field, and NoteSQL only returns the text part of the field, but rich text fields can contain attachments/embedded objects. So, although NoteSQL looks like it'll be useful in the future, for now, it's back to OLE for me (and I just have to scan through all documents instead of trying to use GetAllEntriesByKey() with the "by date" view) :-(