Hi Larry,

I am going to try your code for instantiating a Notes object but one question from the below - in talking to our Notes developer (contractor), he does not think that the query would be optimized in any way because he said that "indexes cannot be attached to a field like in VFP". I had assumed that if it was an ODBC driver that the driver would use whatever indexes it could find. What do you think - optimized or not?

Albert,

1) The Notes ODBC driver does support the basic SQL query syntax. Using SPT or remote views, you can query on a view and the result set will be returned as a VFP cursor. You can also use the object model and return a document collection and parse through that. The query would be optimized within Notes so the major processing would be done going through the collection.