>>>Hi all,
>>>
>>>I'm thinking to use the above to run a table-driven SQL Select which is stored in a memo field. For those who has done this b4, it is advisable in the sense of deterioting speed? Thanks in advance...
>>
>>It'll be slower than macro substitution because EXECScript has to do following steps
>>- Write code, passed as parameter, to a temporary file on disk
>>- Compile it
>>- Run it
>
>Thanks Sergey for the reply. I understand it will be slower but is it bearable? I have tried doing on a small data set and it seems to be OK. Has anyone really used this route for huge data set?
>
>
Farouk,
You missunderstood me. EXECScript has no affect on query performance but adds some overhead in preparing it to run as I described above.
--sb--