>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

I've been doing some Notes automation. AFAIK, there is no way to do SQL SELECT into a Notes database. In otherwords, there is no ODBC driver for Notes. I'm using pure COM automation to the Notes client which is what your contractor is doing.

>
>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?

I haven't found one. If you do locate it, let me know.

>
>Albert Gostick