July 29, 2008 at 7:19 am
I am trying to write an XML schema that takes a view (I'll actually convert it to a stored procedure when I start programming this) and transforms it into XML data to return to VB 2005. The data set itself is very complex, so I want to show you how the data looks and how I would like to return it to VB 2005.
FIELDS:
A
B
C
D
E
F
G
Let's say that fields A,B, and C are "header" information. That means that all the records for a specific condition (A='0000999999', for instance) have the same values for A,B and C.
D-G are "detail" information and can vary for that same recordset between records.
I would like to transform this data into an XML data set such that you have a header for A-C and a "table" type structure for D-G. This will eventually be written to a text file with A-C being tab-delimited on one row, then a tab-delimited row for each occurrence of D-G.
Can someone point me in the right general direction?
August 12, 2008 at 11:54 am
ANYONE????
August 12, 2008 at 12:06 pm
Wouldn't it be easier to return the data to VB in a dataset and then do the XML manipulation there? Once in VB you can use xsl style sheets and .NET has good tools for converting datasets to XML and manipulating XML.
It would also help if you posted simple table schema(s), a few rows of test data, and the XML representation you are looking for so we know if what we propose really meets your needs or even if it sets you on the right path.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply