Stupid number formatting error...

[Phil M <phil at mobleybros dot com>]

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