>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
create cursor test (name C(10), text C(10), children I)
insert into test ('name', 'text') values ('node1', 'text1')
scatter name oTest1
replace name with 'node2', text with 'text2'
scatter name oTest2
oTest1.children=oTest2
Check out the results in the debugger watch window.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
On a somewhat related note, try playing with the ADO Shape language... basically, it's ADO's implementation of SET RELATION -- you add a sub-table as a field, so the field expands, in the debugger for instance, into the child records... as you move through the ado recordset, the "oChild"-like reference reflects only the current child records.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
