>SELECT ; > id; >, !ISNULL((SELECT .T. FROM PivotConstant WHERE EXISTS(SELECT*FROM tree WHERE parentId=T.id))) hasChild; >FROM tree T >>
CLEAR CLOSE DATABASES ALL CLOSE TABLES ALL CREATE CURSOR tree (id I,parentId I NULL) INSERT INTO tree VALUES (1,NULL) INSERT INTO tree VALUES (2,NULL) INSERT INTO tree VALUES (3,1) INSERT INTO tree VALUES (4,1) INSERT INTO tree VALUES (5,2) SELECT ; id; , (SELECT 1 FROM tree WHERE parentId=T.id HAVING COUNT(*)<0) hasChild; INTO CURSOR _R1; FROM tree T