Hi Tamar.
I'm on VFP 8
What does Sys(3091) do ?

Regards,
Gerard



>>Hi Tamar. Thanks for your reply.
>>
>>>YOu could use SYS(3054) to check all your queries.
>>
>>My problem is in trying to identify all places in my apps (There could be 500 forms and 100 prg) where I have used the following syntax:
>> Select ..... where lcAnyVariable = MyFieldName
>> instead of :
>> Select ...... where MyFieldName = lcAnyVariable
>>
>>I have,nt used Sys(3054) but looking at the help it would appear that I first need to locate all the places in my app where I have a select statemnt and then insert this code.
>
>If you're using VFP 9, you can combine SYS(3054) with SYS(3091) to send all the optimization results to a text file. Then you can examine the text file to find the queries that need attention and fix only those.
>
>Tamar