Output to XML

Hi
I have created a table which I export to an XML file for use in a Spry
Dataset

I run commands on the table to sort the columns and then save the
table before exporting as an XML file

I notice that the order of the data in the XML file is different to
the saved version of the access table. The first column appears ok but
the second column is not in the order I would like it

What can I do to fix this please?

Re: Output to XML

On Fri, 18 Jan 2008 18:07:53 -0800 (PST), zazu
wrote:

xml is not sensitive to sort, so this should not be a problem.
-Tom.


>Hi
>I have created a table which I export to an XML file for use in a Spry
>Dataset
>
>I run commands on the table to sort the columns and then save the
>table before exporting as an XML file
>
>I notice that the order of the data in the XML file is different to
>the saved version of the access table. The first column appears ok but
>the second column is not in the order I would like it
>
>What can I do to fix this please?

Re: Output to XML

On Jan 18, 9:07=A0pm, zazu wrote:
> Hi
> I have created a table which I export to an XML file for use in a Spry
> Dataset
>
> I run commands on the table to sort the columns and then save the
> table before exporting as an XML file
>
> I notice that the order of the data in the XML file is different to
> the saved version of the access table. The first column appears ok but
> the second column is not in the order I would like it
>
> What can I do to fix this please?

I agree with Tom that you shouldn't worry about the order being
different. From p. 7 of "Using the Spry Framework":

Once created, the data set object lets you easily display and manage
the data. For example, you can create a simple table that displays
the XML data, and then use simple methods and prperties to reload
data, sort and filter data, or page through data.

I'd say let Access include the ID as part of the XML file and use the
ID to sort the data later.

James A. Fortune
CDMAPoster@FortuneJames.com