Mike Yearwood
Toronto, Ontario, Canada
The function is not dying. It is just not popular. I always believed it is because the docs state that it is not Rushmore Optimizable. Seek isn't really Rushmore Optimizable either, but the docs don't say that.
>
>
>I love the LOOKUP function, but forgot to mention it! Not many use it.
>LOOKUP is probably the fastest way to seek a record and return a value.
>Too bad first parameter is not an expression!!!!
>
>
>
>This is the best VFP function.
>The best of the best is this:
>the REPLACE can do the operation without the index,
>remove the index parameter and if the a index exist VFP optimize it with a true SEEK
>(not like a partial seek done into the FOR clause),
>otherwise it do a scan with 2X faster respext to a FOR .
>
>Sin that this command is dying.
>
>I have put a wish for a
>LOOKUP(expr,...)
>and for
>LOOKUPRECNO(expr,nRecNo,'Alias') ( use a table like a rows array )
>
>Fabio
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