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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only