<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><FONT face=Tahoma size=2><BR></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV>May be, that this can be fixed in sqldb.pp in function
TSQLConnection.GetAsSQLText(Param: TParam) : string;
<BR>...<BR>- ftFloat : Result :=
FloatToStr(Param.AsFloat, FSQLFormatSettings);<BR>+
ftFloat : Result := FloatToStrF(extended(Param.AsFloat),
ffGeneral, 16, 0, FSQLFormatSettings); <BR>...<BR>for me it seems, that works
... See atached program.<BR>What do you think ?<BR>-Laco.<BR><BR><SPAN
class=000551311-12072011> </SPAN></DIV></BLOCKQUOTE>
<DIV type="cite"><SPAN class=000551311-12072011><FONT face=Arial color=#0000ff
size=2>But that won't solve the writing of truncated data as long
as doubles are passed as a string to mysql.</FONT></SPAN></DIV>
<DIV type="cite"><SPAN class=000551311-12072011><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV type="cite"><SPAN class=000551311-12072011><FONT face=Arial color=#0000ff
size=2>Ludo</FONT></SPAN></DIV></BODY></HTML>