Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OpenXML
Message
De
06/09/2002 22:28:16
 
 
À
06/09/2002 10:34:54
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Divers
Thread ID:
00697354
Message ID:
00697844
Vues:
11
>>Do you know of any good examples using VFP to create XML, send it to SQL to have the data inserted into a table?
>
>I have just this for one of my GLGDW 2002 sessions.
>
>There are various options for creating the XML using VFP. That should be easy to find. At a minimum you can use CURSORTOXML().
>
>You can send the XML to a stored procedure as a TEXT or NTEXT parameter. Just watch the encoding. If you use UTF-8, you'll have to use the TEXT datatype of sp_xml_preparedocument will raise an error.
>
>The BOL has some really good examples of using OPENXML(). Do you have any specific questions.
>
>-Mike

Mike,

thanks. I followed those basic steps and couldn't seem to select the data I wanted out of the XML. When things calm down at the office, I will try to put up a sample code of what I was doing. Perhaps you will spot my mistake.

Thanks,
BOB
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform