Urgent: Locale Bug in EmeraldAdmin 2.5.45 (Sorry, ANTS does not w

Peter A. Sang ( (no email) )
Tue, 1 Sep 1998 13:17:17 +0200

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 * http://sang.net * mailto:pesa@sang.net
* Microsoft Solution Provider - Internet/Intranet Specialist *