FieldByName returns integer instead of money
- 5 years agoSorry, I don't have much experience with TC connecting the DB's so I really can't comment you can try but I would try debugging what variable type is coming out of the DB and output it BEFORE you apply any conversion to it https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqobject/getvartype.html 
 testVar = Qry.FieldByName(paramName).ValueLog.Message(aqObject.GetVarType(testVar)) it looks like your DB collation maybe not be what you are expecting, some places use (and can set up the DB) ',' as the decimal seperator e.g. 123.45 (Point 45) 123,456.78 (123 thousand) 
 Alternative DB collation123,45 (Point 45) 123.456,78 (123 thousand) in the latter case 223,00 would correctly evaluate to 223 as the .toFloat can't use the ',' collection as a decimal point are far as I know - there appear to be 2 decimal places at zero and not 3 which would denote a thousand you may have to change around , and . if this is the case