Hi Gerard

I'm really sorry to say this cause I know it's not what you want to hear, but there is no way I'd trust a machine to try to repair such a mistake.

Sometimes you have to pay for the hard lessons. :)

>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.
>
>
>Short of going through each form and prg file manually and looking at each select statement (I could use the search option to look for select) .... but its still going to be a large task to identify the pieces of code where I have it the wrong way around.
>
>I was enquiring if there was a way of 'autoamting' this task.
>
>Regards,
>Gerard
>
>
>
>
>
>>>Thanks for all replies to this topic.
>>>
>>>Since I 'discovered' this strange behavior, I suspect there are other places in my Apps that I have put the field on the rhs, and am not ware of it.
>>>
>>>Is there any tool that would go through all forms and Prf's and identify where a command is not Rushmore optimised (i.e. in my case where the field is on the wrong side of the equals sign )
>>
>>YOu could use SYS(3054) to check all your queries.
>>
>>Tamar