Displaying ADO Retrieved Data with XML Islands - Reviewing the saved file
(Page 4 of 7 )
Although the file is large, it consists basically of two parts, as shown in the browser display of this file after collapsing all the details. As seen in the next picture, the file's two parts are the 'Schema' and the 'Data' represented by their prefixes, 's:' and 'rs:' as shown in the namespaces -- the first four lines in the document which have the prefix xmlns.
The schema section
The next picture shows just one element from the expanded 's' node in the displayed XML file in the browser. You can also see that it is updatable. This particular slice corresponds to the 'Address' field of the Employees table shown in the first picture. The fields are listed alphabetically in the persisted file. The other elements also show the various attributes of the Address field. In the original table, the Address field's Data type is text and field size is 60. The XML attribute with the prefix 'dt' which marks the beginning of each row shows this information. The 'text' has become 'string' and the field size has become 'maxlength.' The schema information therefore is an accurate representation of the data structure.
The Data Section
The next section shows the only row of data taken from the data section. The prefix 'z' marks the beginning of the data. The XML file has only one row of the table returned corresponding to the LastName='Peacock.'
Next: Data types in Access 2003 and XML file >>
More XML Articles
More By Jayaram Krishnaswamy
