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


First:
- Use id = .id because .id = id is not optimizable ( VFP optimize only the left member of a comparison)
Second:
- iif(.name = name,"Yes","No") fire a error because the VFP SELECT-SQL parser have a bug

use this:

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