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 *