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.
_______________________________________________
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>
