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

It's sys(3092). The help file says it

"Specifies a file to which Rushmore optimization levels for queries are output."


>
>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