Thanks a lot Hank,
Unfortunately, I can't have a webservice producing the XML.
This is a VFP desktop accounting application that's installed in thousands of customers. The desktop application has to output the XML from data in the SQL Database and I can't easily have a webservice installed in every customer.
But i gave me an idea. I can try to produce the requiered XML using the FOR XML clause in T-SQL directly form the SQL Server.
I'll give it a try.
Thanks
>I had to do that recently for a model involving about 6 interrelated tables, with child and grandchild tables. Here are the steps I used (as remembered...):
>
>1) created the data model in xCase (you could do this manually, see Step 2).
>2) created an SQL model from step 1) (you could manually create it in the SQL Manager, of course)
>3) created a new Web Project in VS
>4) added a web service to the web project
>5) added a dataset to the web project
>6) imported the SQL database structure into the dataset
>7) created the web service
>8) tested the web service
>9) the XML I wanted was in the WSDL; by testing a call that returned the dataset (you have to create a method that does this, of course), I got the schema by itself.
>10) tested the XML in Altova's XMLSpy, generating data based on the schema. Had to remove one duplicate line which was generated by VS where there were two children of one of the entities.
>
>That's a rough outline, from memory. Good luck,
>
>Hank
>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only