Re: [fpc-devel] SQLite and ftFmtBCD

2011-05-11 Thread LacaK
or better: ftFmtBCD: begin if P.AsFMTBCD.Precision 15 then //we are out of REAL range, so we must bind as BLOB begin s tr1=BCDTOStrP.AsFMTBCD,SQLFormatSettings); checkerror(sqlite3_bind_blob(fstatement,I,pcharstr(str1), length(str1),

[fpc-devel] SQLite and ftFmtBCD

2011-05-10 Thread LacaK
Hi Joost (and others also ;-), I comment your question about http://bugs.freepascal.org/view.php?id=18809 here. (because I do not know what comment here and what in bug tracker) I see problem in fact, that AsString returns number formated using locale specific DecimalSeparator. So if FmtBCD

Re: [fpc-devel] SQLite and ftFmtBCD

2011-05-10 Thread Joost van der Sluis
On Tue, 2011-05-10 at 12:39 +0200, LacaK wrote: Hi Joost (and others also ;-), I comment your question about http://bugs.freepascal.org/view.php?id=18809 here. (because I do not know what comment here and what in bug tracker) I see problem in fact, that AsString returns number formated

Re: [fpc-devel] SQLite and ftFmtBCD

2011-05-10 Thread LacaK
I'll look at this solution. I'm a little bit confused about SQLFormatSettings and why it was implemented as it is now. I'll have to investigate this. IMO for locale independent formatting numeric, date, time values according to sql standard or better: ftFmtBCD: begin if