Hi Marcia,
another tips is:
Search for a first occurrence of a value, as MyValue, is very frequently.
Standard VFP command is:
SELECT MyTable
LOCATE FOR MyField=MyValue
IF FOUND()
...
ENDIF
This need set workarea, and Rushmore optimization is not very good,
besides, if MyValue is a variable/field, FOR clause read MyValue for each comparison.
=LOOKUP(MyTable.MyField,MyValue,MyTable.MyField)
IF !EOF('MyTable')
...
ENDIF
is faster: double faster if no index exist, exponential faster if index exist.
Attention is need if MyTable have a index active.
Fabio
Précédent
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