On 25-7-2011 13:31, Ludo Brands wrote: >> So you're saying that this: >> <ADateTime>2011-07-22T15:00:00+02:00</ADateTime> >> can be simplified to this: <ADateTime>2011-07-22T15:00:00</ADateTime> >> ? > It does. It uses TZ to convert if specified but assumes local time if not > specified. Tested this when importing access 2010 data.
Ok, that simplifies things a lot. > I think you misunderstood me. All the schema information available should be > specified correctly in the XML file. What is not relevant, IMHO, is the > format in which it is presented as long it is correctly and fully > interpreted by the importer. So if the access 2002 format you created fits > the bill, then that should be sufficient. Totally agreed. > There are for example a lot of > presentation type of atttributes added in access 2010 (display width, > locale, etc) which are not part of the real data schema. No reason to > emulate (invent) these properties for our purpose. Agreed. I did see one improvement in your 2010 export: descending indexes are supported as opposed to Access XP.... I'll tweak the format to spit that out & see if Access XP can read it... Regards, Reinier _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal