Financial Troubles?
My system under test has a finance piece, and I'm running into trouble with the way TestComplete handles non-integers. As far as I can tell, my numerical options are to use integers or floats. The ...
Forum Discussion
Are you scripting this?
What language?
As I suspect the language in use is likely to affect the options available ...
Let me clarify my previous response a bit. As far as I can tell, there is no way to explicitly cast a variable as any specific type in any of the lanugages supported by TestComplete, except DelphiScript and VBScript. In the case of DelphiScript, the only base types it supports are integer, float, boolean and string.
Which leaves me with VBScript. According to Microsoft, VBScript does support a currency data type (but still no decimal), so that would work as far as that goes. But in researching this, I couldn't help but notice that 'currency' only goes to 4 decimal places. Does that mean that I could, theoretically, get a similar (if not equal) level of precision by just rounding my floats to 4 decimal places? That would certainly be a lot easier than trying to refactor my scripts. And if I can get a sense that this is generally accepted as a "good enough" practice, I might just do that.
Thoughts?
How about using the .NET Decimal type? It has 28-29 significant digits, and is more presice than the scripting data types.
// JScript
var value = dotNET.System.Decimal.zctor_5(351148.87); // from float
var value2 = dotNET.System.Decimal.Parse("351148.87"); // from stringNote that you'll probably need to handle Decimals using their own methods - .CompareTo, .Equals, .Add, .Subtract and so on.
I'm very interested in using the .Net decimal, it seems like it would be perfect. I'm being told I've already spent too much time on this test, however, so I'll have to file it away for later use...
I'm a VBScript guy myself but never run into any rounding problems. But then, I don't deal with large amounts of financial transactions like you.
Might even be worth writing your own rounding function. Even if it means converting to a string and back to reduce it to the right number of decimal places.
Not familiar with jScript at all I'm afraid ....
Okay, here's what I ended up doing - for now at least, for anyone who is interested. I created a simple function:
function handleFloats(num)
{
/*Multiplies num by 10,000, rounds it ot the nearest integer, then divides by 10,000 in an attempt to set it at 4 decimals.*/
var result = Math.round(num*10000)/10000;
return result;
}
It's a bit kludgey, but it will do for now, at least.
