I have a lookup view in my database with ‘Index Refresh’ Property set to ‘Manual’ in the design.
I am using this view in my lotus script to get handle to all the documents in this view and process them one by one as shown below.
Set vwLU = db.GetView(“viewName”)
Call vwLU.Refresh 'To refresh the view as per Lotus Help Doc
vwLU.AutoUpdate = False ’ To improve performance as per LS Help Doc
Set doc = vwLU.GetFirstDocument
While Not ndoc Is Nothing
' Document Processing
Set doc = vwLU.GetNextDocument(doc)
Wend
As a result I am always ending up in some documents remain unprocessed. It seems like the refresh method is not refershing the view, so the script is missing those documents to process. But If I am setting the ‘Index Refresh’ property as ‘Automatic’ in the view design, then all the documents are getting processed by the same above script.
I want to keep the view ‘Manual’, to avoid extra indexing overhead over Domino server, and possible performance issues. But it seems like I cannot rely in NotesView.Refresh to get handle to all the documents.
I would really appreciate any help and Ideas.
Thanks
Bilal Ahmed