On 25-7-2011 17:37, Ludo Brands wrote: > >> 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...
Still to do... > Tested the creation of index info from MySQL SQLQuery and found some issues. > > Line 222: > > if IsPublishedProp(DataSet, 'ServerIndexDefs') then > begin > IndexDefs := GetObjectProp(DataSet, 'ServerIndexDefs') as > TIndexDefs; > > IndexDefs isn't the same as ServerIndexDefs for TCustomSQLQuery. IndexDefs > just returns one index 'DEFAULT_ORDER' which isn't exported. Ok, replaced with ServerIndexDefs. Seems simplest. > Line 252 > Typo: Index.Fields instead of Index.Name. Reinier: Fixed > After these changes, import in access 2002 and 2010 is ok. Multiple field > indices is working also? It should be as it now takes the fields property (a semicolon delimited list of fields according to the help) & replaces ; with a space, which is the format that appears in my test xml. Ludo (and anyone else): you can find the latest source at: https://bitbucket.org/reiniero/fpc_laz_patch_playground/src in the directory fcl_db_export In the meantime, I've finished the ADO.Net export functionality. I'd appreciate further test reports! One thing outstanding is enabling support for export without XSD; at the moment it doesn't write a file. Thanks for the help, Reinier _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
