Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2011-07

TR : RE : RE : Patch: new XML export for FCL-DB, was: SDFDataset multiline support: request for a look at patch+test, issue 17285

3 messages · 2 people ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Ludo Brands

-----Message d'origine-----
De : Ludo Brands
Envoyé : samedi 23 juillet 2011 13:24
À : 'Reinier Olislagers'
Objet : RE : RE : RE : [fpc-pascal] Patch: new XML export for FCL-DB, was: SDFDataset multiline support: request for a look at patch+test, issue 17285

Doesn't crash now for me, but I do get these errors in Access now (If you don't speak Dutch: Regel=Line, Onbekende eigenschap=Unknown property, Syntaxisfout: syntax error):

Same in flemish ;)

XML-tekst Foutbericht Regel 4: name Onbekende eigenschap Regel 18: minOccurs Syntaxisfout Regel 23: minOccurs Syntaxisfout

od:minOccurs should be minOccurs

Show quoted text 15 lines
Regel 25: base Onbekende eigenschap Regel 30: minOccurs Syntaxisfout Regel 32: base Onbekende eigenschap Regel 37: minOccurs Syntaxisfout Regel 42: minOccurs Syntaxisfout Regel 44: base Onbekende eigenschap Regel 50: minOccurs Syntaxisfout I'll have a look at those as well.. Also, your fix for UTF8 support for data works. Now I'm going to have a look at the field names. Thanks, Reinier/BigChimp

Reply by email

Ludo Brands

-----Message d'origine-----
De : Ludo Brands
Envoyé : samedi 23 juillet 2011 13:35
À : 'Reinier Olislagers'
Objet : RE : RE : RE : [fpc-pascal] Patch: new XML export for FCL-DB, was: SDFDataset multiline support: request for a look at patch+test, issue 17285

Regel 4: name Onbekende eigenschap
215
    // Add table list. If we're exporting an FPC dataset, there
    // will only be one table.
    FXSDTableListNode := FOutputDoc.CreateElement('xsd:element');

Was

    FXSDTableListNode := FOutputDoc.CreateElement('element');
Regel 18: minOccurs Syntaxisfout Regel 23: minOccurs Syntaxisfout Regel 25: base Onbekende eigenschap
228
      RestrictionNode := FOutputDoc.CreateElement('xsd:restriction');

Was

      RestrictionNode := FOutputDoc.CreateElement('xsd.restriction');

The decimal point needs also to be localised ;(

Ludo

Reply by email

Reinier Olislagers
to Ludo Brands

Sorry, didn't realise Ludo had sent his replies to the list as well.

Summary and item for discussion below:

Ludo Brands wrote 6 lines
-----Message d'origine----- De : Ludo Brands > Regel 4: name Onbekende eigenschap

<snip helpful corrections> Was

RestrictionNode := FOutputDoc.CreateElement('xsd.restriction');

Thanks Ludo, have fixed those.

Show quoted text 5 lines
The decimal point needs also to be localised ;( Ludo

You are correct. I had explicitly left it as a . - must have taken a , for a . when tired.

What a ridiculous idea, to generate different exports for the same data depending on what country you are in.

I might just leave it in US format as a . - this will at least create a consistent format and allow import by US/Anglophone countries. What do you
think?

Better yet, I'll have a look at how newer versions of Access and ADO.NET do this,
maybe MS have fixed this since then.
If anyone wants to try exporting to XML with inline XSD in newer versions of Access, please do; you can e.g. paste the XML on pastebin.ca and send me a reminder. Thanks.

What's also strange is that currency fields don't have a currency symbol (e.g. €); I've got Dutch settings with . as thousands separator - no trace of a . in currency output. But it does output , as a decimal marker, not .
Weird.
Once again, I'll look at how newer Access versions and ADO.Net do this.

Thanks,
Reinier

Reply by email