Accessing Regional Settings and using in SQL Queries 
Author Message
 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 under the [Intnl]
settings. This way you can determine what to convert to decimal points.


David Thomas

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

Sun, 06 Jun 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. SQL Query and Regional settings

2. SQL Queries & Regional settings

3. Decimal point in Regional Settings affects dynamic SQL query

4. Get Regional Settings using Access 2.0

5. Regional Settings & Single datatype to SQL Server

6. Problems with regional settings and SQL statement

7. Regional setting invoking sql command

8. Invalid SQL statement when changing regional settings

9. Regional Settings & Single datatype to SQL Server

10. Setting SQL Server query processing options via Access/VBA

11. Formatting integers using regional settings

12. Merge replicatinon using other regional setting than English with SQLCE


Powered by phpBB® Forum Software