On Sep 28, 2006, at 11:01 AM, Phil M 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
_______________________________________________
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>
|