On Sep 28, 2006, at 11:14 AM, Phil M wrote:
On 28.09.2006, at 10:07, Norman Palardy wrote:
When writing SQL INSERT strings, I thought I was being "safe"
using the Format() function.
The problem occurs when using Format() on a Double where the
local uses a Comma (,) instead of a Period (.) and
REALSQLdatabase thinks one value is two fields (the SQL string
sure looks like it is written that way).
The moral of the story... use ReplaceAll on the formatted string
before adding it to the SQL string!
Ouch ... yeah that would do it
SQL is not internationally savvy in many many ways
I have to look into this further, but the result of this bug is
even worse. It appears that the SQL is not written to the
REALSQLdatabase *and* no DB.Error occurs (a silent death).
I am going to figure this out and report it ASAP if I can reproduce
it in a simple project.
The second portion of your double is probably in the wrong column
since SQLite will let you do that.
Or do you not get the row at all ?
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
