Hi Marc, > For example: > > "SELECT something FROM anytable WHERE afield=3.45" > > In a german localized installation the value string is mostly > > "3,45" > > most other locales are using > > "3.45" > > If I want to make SQL strings myself and fire them from OO.o to a > connected DB this difference has to be detected and handled.
Another idea: Use a prepared statement for this (with "... WHERE afield=?"), and fill in the parameter as double value. This completely spares the string-ization (the system driver would translate your string back into a double, anyway). Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
