Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Neat Fox-to-Sql parm object works but has problem
Message
 
 
À
17/09/2003 10:27:31
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00829659
Message ID:
00829880
Vues:
28
You can use < pre > and < /pre > tags (w/o spaces) to preserve formatting. Why didn't you try
SELECT *
        FROM    OPENXML ( @idoc , '/*/*' )
        WITH    ( pk INT '.')
?

>Here is some SQL test code that I am using along with the results that I get (at bottom). Actually, I had to remove the XML from this reply because of "style attributes not allowed inside a tag".
>
>declare @idoc int
>declare @doc varchar(8000)
>
>set @doc ='
>{XML Pasted in from fox's
> "CURSORTOXML([SqlParm],[lxData],1,2,0,[],[],[http://www.ourcompany.com])"
>'
>--Create an internal representation of the XML document.
>exec sp_xml_preparedocument @idoc OUTPUT, @doc
>
>SELECT *
> FROM OPENXML ( @idoc , '/*/*' )
> WITH ( pk INT )
>
>EXEC sp_xml_removedocument @idoc
>
>/*
>I get this:
>
>pk
>-----
>NULL
>NULL
>NULL
>
>*/
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform