XQuery Help

Question

I have this xml on a table:

<BookData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<DataVersion>

<Name>ABC</Name>

<Data xsi:type="xsd:string">DEF</Data>

</DataVersion>

</BookData>'

I want to modified the xml with this xquery:

UPDATE LibraryOverride SET XMLConfig.modify(

'declare namespace ns="http://www.w3.org/2001/XMLSchema-instance";

'replace value of (//ns:BookData/DataVersion/Data)[1] with "TEST"')

Where PropertyOverrideID = 1

I am getting this error:

XQuery [LibraryOverride.XMLConfig.modify()]: The target of 'replace value of' must be a non-metadata attribute or an element with simple typed content, found 'element(Data,xdt:untyped) ?'

Answer 1

For untyped xml I know you can specify that its the text of the element that you want to modify:

'replace value of (//ns:BookData/DataVersion/Data/text())[1] with "TEST"')

For typed xml you can specify the type like so:

'replace value of (//ns:BookData/DataVersion/Data)[1] with xs:string("TEST")')

Answer 2

Thanks Declan. The solution works perfectly.

Gopinath M

Tech Thoughts

Answer 3

I learned some where that ,We cant use replace for untyped -xml

Is it true