Format for numeric value

[trajmo]

Hello,

I am trying to specify a property checkpoint for my fild which contains numbers, to check the format, in the code of my desktop application in Delphi is specified #,##0.00, how can i do it with the same format to be checked in my keyword.

Thanks,

[tristaanogre]

Have you looked at using aqString.Format in a code expression in your property checkpoint?

https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqstring/format.html

https://support.smartbear.com/testcomplete/docs/keyword-testing/dialogs/edit-expression.html?q=Code%...

[trajmo]

Thanks for your quick response.

I am still trying to resolve my issue, i read all the articles for aqString.Format method but i cannot figure out how to do it. I am sending the printscreens of my error and my property check point expression.

For sure i am wrong somewhere.

In my code of the application the format in Delphi is specified by '#,##0.00'

But i dont know how to do it in TC.

[tristaanogre]

Well, for one thing, the "Property" field should be the field that indicates which property of the object you're going to do a check against... you don't put the "aqString.Format" code in there....

So... you're doing a property checkpoint... meaning you want to check that the value of a property matches an expected value.  So...  in your checkpoint, the "Object" field should be everything all the way up to but NOT including the "wText"... that should be set up as an "Onscreen Object".   The "Property" field should be a string containng "wText".

It's the "Value" field where it sounds like you want to use the Code Expression for "aqString.Format".  Basically, this is where you're going to put in the value that you want to compare... 

Start with that... 

[trajmo]

Actually i dont have a specific value to be checked, i want to check the format for any value entered how it is displayed, i didnt make it still to find a solution, because i cannot find any particular example when only the format is checked, all the examples are for specific values. Can i do it in keyword with Code expression with aqString.Format and how to specify the format within the aqString.Format(??????)?

Here it is the original code for the Format in Delphi:

begin
FilterDFT := CompleteRound(FloatToStr(Dan));
FilterDFTPrimac := CompleteRound(FloatToStr(DanPrimac));
DFT.Text := FormatFloat('#,##0.00',StrToFloat(CompleteRound(FloatToStr(Dan))));
VKIznos.Text := FormatFloat('#,##0.00',StrToFloat(CompleteRound(FloatToStr(Dan + StrToFloat(FilterIznos) + StrToFloat(Provizija.Text)))));
end;

[tristaanogre · Accepted solution]

Now it's clear... so, you're simply wanting to make sure that the contents of the property match a particular format.

So...  When setting up your property checkpoint, one of the options in the "Condition" parameter is "cmpMatches".  When you select that, then in the "Value" parameter, you enter the regular expression for the format you want as a "String", not a code expression.

[mioani]

But this way compares the both properties as strings. If I enter an expression a value as a string it gives me a hard coded value, and the field I want to check is constantly changing which makes the checkpoint useless. 

I have a field in my app that can have from 1 to 15 digit numbers and I want to check whether every and each of those numbers entered has the specific format of thousands separated by commas and decimals separated by a dot.

What do you suggest goes in the blank space? Is this right?

Thank you and sorry 🙂

[tristaanogre · Accepted solution]

In the blank space in the value field I believe should be the regular expression for the format that you're wanting to check... and yes, it is a "number" techincally, but the wText field in the object is a string property.

You MAY end up not being able to use the built in property check point but might need to write a script routine that you call from within your keyword test to do the validation/check of the contents.  Again, regular expressions are going to be your friend here.

[mioani]

This was very enlightening. Thank you