slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: SQL error on French locale

Nicolas Galler
Posts: 93

SQL error on French locale Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 02 Apr 08 12:17 PM

I am looking for a best practice for the following situation:
SQL server is on US locale
Workstation is on French locale

I have a script running a statement such as:
x = 0.12
con.Execute "UPDATE INVOICE SET TOTAL=" & x

The problem is this statement gets converted to
UPDATE INVOICE SET TOTAL=0,12

and the SQL server will not parse it.

So far the best solution I have found is something like:

prevLocale = GetLocale()
SetLocale 1033
con.Execute "UPDATE INVOICE SET TOTAL=" & x
SetLocale prevLocale

Looks pretty ugly though. Is there a better way? Could the above code cause problems depending on the remote database setting?

Thanks
Nick

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/23/2025 6:53:44 AM