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.