Den 2011-07-02 21:39 skrev jclichthouse såhär:

> Hello everybody,
>
> After a search to convert the MS-Sql to Firebird i found a problem.
> Firebird is not a able to work with XML.
>
> Can somebody tel my if there is tool/UDF for this, if not some help/info
> about creating a udf in C# would be appreciated ( can not write/read
> C/C++ yet ).
>
> This is what i no / need to do:
> the stored procedure has a parameter string that contains the XML. I
> need to read the XML and load it in a ( temp ) table.
>
> Here is a example of XML
> <DocumentElement><Phone><PhoneTypeNR>1</TelTypeNR>
> <LandNr>31</LandNr>
> <Netnummer>06</Netnummer>
> <AbonneeNr>6060606</AbonneeNr></Phone>
> <Phone>
> <PhoneTypeNR>4</TelTypeNR>
> <LandNr>31</LandNr>
> <Netnummer>0475</Netnummer>
> <AbonneeNr>8080808</AbonneeNr></Phone></DocumentElement>
>
> If you want to know more please read this thread
> http://tech.groups.yahoo.com/group/IB-Conversions/message/657
> Title: Convert ms-sql to firebird openxml problem

My first thought is why don't you parse the XML in your app instead of
inside FB?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64