*--- 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 tablesWhy 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?
use c:\foxtemp\table1 scatter memo name loTest sele iif(m.loTest.name = name,"Yes","No ") as indicator from loTest where id = m.loTest.id close tables