Information générale
Catégorie:
Codage, syntaxe et commandes
Sure... Then again, in many cases, this will be partially optimizable, and you will still get a big bang for the buck.
Good example!!
>>First off, I am not sure why we are even discussing Locate. Unless we are talking about a non-indexed field, it has NO value. Best to use Seek.
>
>John,
>
>Another place where LOCATE is of value is when the criteria is complex and there is no particular index that would allow a seek;
>
>LOCATE FOR State = "PA" AND Amount >= 1000 AND Amount <= 10000
>
>There may be indexes on State and Amount, but there is no way to SEEK that criteria.
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