Accessing Regional Settings and using in SQL Queries
Access SQL will only accept the , seperator. Instead make sure you change
all commas in numbers to decimal points before sending. It is still a safe
bet to grab the internatinal settings from the win.in under the [Intnl]
settings. This way you can determine what to convert to decimal points.
Regards
David Thomas
Quote:
> I need to send floating point values to an Access database use SQL.
> That's simple enough. The problem is that this is a internationally
aware
> software and if someone has their regional setting for decimal to ",",
> then I get a SQL error because it interprets each of these as a list etc
