RE: Urgent: Locale Bug in EmeraldAdmin 2.5.45 (Sorry, ANTS does n

Peter A. Sang ( (no email) )
Tue, 1 Sep 1998 14:11:20 +0200

A remark to this problem:
with the fix outlined below, the amount is saved & reloaded as '320,00'
instead of '3,20'.
AAARGH, who has the time to dig into that?

-----Original Message-----
From: Peter A. Sang []
Sent: Tuesday, September 01, 1998 1:17 PM
To: ''
Subject: Urgent: Locale Bug in EmeraldAdmin 2.5.45 (Sorry, ANTS does not
w ork for this problem due to lots of ''''''''''''')
Importance: High

Hi Dale,

Trying to change a rate I get a 'SAVE FAILED', debug shows this query:

UPDATE Rates SET Description='Rate_Dial-PC', StandardHours=25,
StandardCharge=0, OverCharge=3,20, OverRefuse=1, PrimaryPay=0,
PrimaryStart=0, PrimaryStop=0, PrimaryCharge=0, PrimaryOverCharge=0
Where RateID = 11

Problem is with 'Overcharge = 3<comma>20', this query must be
constructed differently.

Since implicit conversion from datatype 'varchar' to datatype 'money'
does NOT work, the only obvious way is

....., OverCharge=convert(money,'3,20'),....

for ****EVERY***** money/decimal/real value where the comma is also a
decimal delimiter like in Germany.

Sorry, but if you like it or not.....out of my knowledge there's no
other workaround.

Mit freundlichem Gruss,

Peter A. Sang
SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
T: +49-201-82020-0 * F:-40 * *
* Microsoft Solution Provider - Internet/Intranet Specialist *