>I realize this is not your normal VFP question but I have to integrate VFP with some Notes databases - and it appears that I am dealing with a 3rd party contractor who does not know the Notes API inside out. My questions are:
>
>1) anyone know if Notes supports any of the SQL-Select stuff - he is trying to do a lookup that it taking forever ie. 20 minutes (by iterating through an object heirarchy). An optimized query that used some of the indexes that I know he has in his setup might speed things up
>
>2) I could not find a "Notes" section in the UT (did not really expect too but could not even find a VB forum). Is there one? If not, anyone know of a site that compares well to our beloved UT but for Notes?
>

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.

As an aside, 20 minutes?!? How many documents are returned? 20 minutes just seems like a long time.

2) There is a Lotus Notes forum. Go to Account Setup - Forums and check the Lotus Notes box. There is also a VB forum.

HTH.