Information générale
Forum:
Microsoft SQL Server
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement