Hi,
I do not fully understand what you intend, but I guess that the subexpression :
( for $v2 in document(“F:\xquery\taskplan.xml”)//LSQLResults/Row
return {$v2/unit} )
//Row
is empty.
The for clause retrieves Row element nodes. From each one of these you take the
set of unit element children and wrap these into a new Row element. From the set
of all these Row elements you select all Row descendants. Unless there are again
Row elements below unit this is an empty sequence.
Try to replace this subexpression with something better. I can advise you here
when you tell me what you intend.
Are you aware that case matters in XQuery, i.e. Row != row and unit != Unit ?
Regards,
Juliane.
#API-Management#webMethods#Tamino