Hi Larry,

I will check out the Notes ODBC driver and give it a whirl. The data is actually in Domino Doc which sits on top of Notes. The guy was using the API to get a object reference to the library.

What we were trying to do is to get the Binder ID for a binder that matched a record in VFP - and we are matching on lastname/firstname plus a client number - all of which are properties of the binder. The guy was opening Notes, getting an object reference to Notes, then going to the correct file cabinet (which we know ahead so no searching there - only 8 cabinets) but then to get the correct binder, it was iterating through the file cabinet binder by binder checking all 3 properties (last, first and client number) and when found, returning the Binder ID. Once we have that (which we then store on the VFP side - a 64 character ID), getting the documents for that binder is quite fast. But this initial "linking" is dog slow.

So I was thinking, if there are indexes on these properties in Notes, I should be able to do a query against the file cabinet (or library) a lot faster and get a result back to a cursor. Just forget the call to the API to get the Binder ID.

albert

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