>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.
infact i call it funny!