Information générale
Catégorie:
Codage, syntaxe et commandes
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement