[fpc-pascal] Patch: new XML export for FCL-DB, was: SDFDataset multiline support: request for a look at patch+test, issue 17285
ludo.brands at free.fr
Sat Jul 23 14:06:33 CEST 2011
Don't know when it started, but at one point messages weren't going to the
list anymore. Since my incoming messages are routed by title [fpc-pascal]
they still showed up as coming from the list... Hence the confusion.
> > The decimal point needs also to be localised ;(
> 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.
At one time, even VBA was localised. You couldn't run scripts created on a
french excel on a german excel fe.
> Actually, I might just leave it in US format as a . - this
> will at least fix the 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 do this, maybe MS
> have fixed this since then)
DecimalSeparator is set to the system value in Sysutils and correspond to
the machines localisation. You shouldn't hardcode it.
> 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.
The currency sign and thousands separators is for display use only. I
haven't seen any data format using them. Luckily, that is. The decimal
separator is already confusing enough.
More information about the fpc-pascal