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),
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
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
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