Hi Fabio,

You are correct. There is a bug here. The following query is illegal in VFP and should fail:

SELECT ;
 id;
, !ISNULL((SELECT .T. FROM PivotConstant WHERE EXISTS(SELECT*FROM tree WHERE parentId=T.id))) hasChild;
FROM tree T

It is illegal in VFP because correlation is supported only to immediate parent query.

Thanks,
Aleksey.