Rodd

This is a known problem that I have suffered from and there have been several threads like yours. Set the .id and .name props. to local variables first, use this, and the select will work.

Terry

>Given the following two code snippets:
>
>

*--- Sample 1 -- Works fine
>use c:\foxtemp\table1
>scatter memo name loTest
>with loTest
>   sele * from loTest where .id = id
>endwith
>close tables
>

>
>

*--- Sample 2 -- Syntax Error
>use c:\foxtemp\table1
>scatter memo name loTest
>with loTest
>   sele iif(.name = name,"Yes","No") as indicator from loTest where .id = id
>endwith
>close tables
>

>
>Why does Sample 1 work fine and Sample 2 gives me a syntax error. Why can't the query work with .property in the select items but it can in the where clause?
>
>Thanks for your help!
>
>Rodd