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