Hi Alan,

> -----Original Message-----
> Subject: [IB-Conversions] Re: Convert ms-sql to firebird openxml problem
>
> Paul Thanks for the response
>
> > - don't mix DML and DDL (you can if you use dynamic sql, but it's not
> > advised and bad practice).
> After a search i found more info on what you are saying. More study is
> needed to understand and implement this ( in MS-Sql also ).
>
> >temp tables are explained quite well in the firebird help
> This is very helpful, i will test it to understand more about it.
>
> There is only one thing i need to have some info about and that is reading the
> (open)XML string.
>
> For example : Lets say i have to use ( read ) this XML string
> <DocumentElement> <Phone> <TelTypeNR>1</TelTypeNR>
> <LandNr>31</LandNr> <Netnummer>06</Netnummer>
> <AbonneeNr>6060606</AbonneeNr> </Phone> <Phone>
> <TelTypeNR>4</TelTypeNR> <LandNr>31</LandNr>
> <Netnummer>0475</Netnummer> <AbonneeNr>8080808</AbonneeNr>
> </Phone> </DocumentElement>
>
> Tanks again for the help.
>
> Edwin
>
> --- In IB-Conversions@yahoogroups.com <mailto:IB-
> Conversions%40yahoogroups.com> , Paul Lopez <paul.lopez@...> wrote:
> >
> > > -----Original Message-----
> > > Subject: [IB-Conversions] Convert ms-sql to firebird openxml problem
> > >
> > > Hi,
> > >
> > > After a long search on google I stil have no clue how to convert this code.
> > >
> > > [code]
> > > ALTER PROCEDURE [dbo].[PhonePerson_TR] ( @PersoonNr int ,
> @XmlPhone
> > > nvarchar(2000) = ''
> > >
> > > , @user nvarchar(50)
> > > , @returnValue int output
> > > )
> > >
> > > AS
> > > BEGIN
> > > if len(@XmlPhone) > 0
> > > BEGIN
> > > BEGIN TRY
> > >
> > > /* ********** ********** BOF process xml **********
> ********** */
> > >
> > > -- Create a temp table to store xml info DECLARE @TempTable table (
> > > PersoonNr int default -1 , TelefoonNr int default -1 , TelTypeNr
> > > smallint , LandNr smallint , NetNummer nvarchar(10) default -1 ,
> > > AbonneeNr
> > > nvarchar(80) default -1 , used int default -1
> > > )
> > >
> > > DECLARE @XMLDoc INT
> > > EXEC sp_xml_preparedocument @XMLDoc OUTPUT, @XmlPhone;
> > >
> > > -- insert the xml in the temp table
> > > INSERT INTO @TempTable (TelefoonNr, TelTypeNr, LandNr,
> NetNummer,
> > > AbonneeNr)
> > > SELECT TelefoonNr, TelTypeNr, LandNr, NetNummer, AbonneeNr FROM
> > > OPENXML(@XMLDoc, '/DocumentElement/Phone',2) WITH ( TelefoonNr
> INT ,
> > > TelTypeNR INT , LandNr NVARCHAR(5) , Netnummer nvarchar(10) ,
> > > AbonneeNr nvarchar(80) );
> > >
> > > -- Update the columns that are not used yet.
> > > update @TempTable
> > > set LandNr = null
> > > , Netnummer = null;
> > >
> > > /* ********** ********** EOF process xml ********** **********
> */
> > > -- more code using transactions
> > > [/code]
> > >
> > > Can you tel me how to get started, I have not much knowledge of fb yet.
> > >
> > > any help is welcome
> > >
> > > Edwin
> >
> > Hi Edwin,
> >
> > You might want to try some of the following to get you started:
> >
> > - parameters that have defaults : all params following the first param
> > that has a default need to have a default value as well
> > - don't mix DML and DDL (you can if you use dynamic sql, but it's not
> advised and bad practice).
> > - create the temp tables as part of your metadata scripts outside of
> > the stored procedure
> > - temp tables are explained quite well in the firebird help
> > (http://www.firebirdsql.org/refdocs/langrefupd21-ddl-table.html)
> >
> > Good luck!
> >
> > Paul.
> >

I don't have any great news for you. At the moment, firebird does not support x-path queries (AFAIK).

Not sure if you can consider a third party UDF or create one yourself to help with what you need to achieve.

Paul.