>This from my experience and observation when I was writing test cases for the VFP team back in 2002. I no longer have access to those statistics. But I do remimber the performance tests performing a larger loop (10000+) interations using Macros, Evaluate, and ExecScript.
>
>I retrack my statement. I did the tests and Yes in simple statements, Macros are faster then ExecScript. But I still believe Evaluate() will out perform Macros.
Yes, but not in select-SQL, where they should not be used. Suggestion to use
select evaluate(lcExep) as (lcField) is simply wrong.
If it's not broken, fix it until it is.
My Blog