Comparing table data in IF not working

Hello,

I have this weird problem were everything seems correct but TC isn't doing the correct steps.

I have a data driven loop, and I am going to check if the product number is a specific product, and it should do the steps I want.

This has worked in the past, not sure why it stopped working.

In the image below, in the blue box, the product number is filled in - this is correct.

For the sake of testing, I added the yellow box - these also give and store the correct values.

The problem is in the red box, for some unknown reason it just skips the if.

Below is a small snippet of the test log, and you can see that the log action provided the correct product number.

Also, you can see that the text in the textbox is also the correct value.

And lastly a screenshot of the if itself.

Can anybody help me notice the issue?

Thanks in advance.

Luuk

rraghvani
9 months ago
Are you able to open your project file (.mds file) in Notepad++ or something similar to view your project variables. For example,

which represents this in TC,

Can you see any spaces inbetween the quotes of Cells?

28 Replies

rraghvani
Champion Level 3
9 months ago
Great!

Ignore my previous suggestions. Could you remove "&#10" from each of your variables. Then try to your run project again, it should work - accept for //Purchase Hellwege where Project.Variables.SupplierID == "BUN001", which you'll need to update i.e. remove "\r\n" from "L-24-119-00\r\n")

ASCII value 13 refers to Carriage Return and 10 is Line Feed.

"Again, I can't see anything wrong with the code you have provided. It always leads me back to your data." - it's your data 😁
rraghvani
Champion Level 3
9 months ago
The log output may not show "hidden" characters, so don't always rely on it.

I can't see anything wrong with your keyword test, so it must be the data format.
rraghvani
Champion Level 3
9 months ago
I still can't see anything wrong in the code!

Could you insert the following code expression

"\"" + Project.Variables.PurchaseOrderProducts.Iterator.Value("ProductNumber") + "\""

into your Log.Message messages

It should output the product number in double quotes - this should indicate if there's spaces in your data
Luukdb
Contributor
9 months ago
Ah yes, I disabled the changes I made to test out my default code. The disabled code is the part that looks if there is a column with or without dashes, and store the product number in a variable.

The IF at the bottom of the screenshot, is the check he should be doing because the product number is the same.
rraghvani
Champion Level 3
9 months ago
Use a standard text editor like Notepad or Notepad++ and save it.
rraghvani
Champion Level 3
9 months ago
In the blue section of "If Object", does the if statement also sets the text for ProductNumber or does it only set it in the else statement? The red section may fail because of this.

Should Value2 value be in quotes?

Apart from that, I can't really see anything wrong.
- Luukdb
  Contributor
  9 months ago
  The "If Object" in the blue section is to check if a column for the product number without - is available.
  
  If so, it will enter the product number without -.
  
  But in this case that column is not available.
  
  I am not sure if Value2 should be in quotes, I can try, I never put quotes there.
  - Marsha_R
    Champion Level 3
    9 months ago
    Even though the values look like they match, the If is probably failing because there's a type mismatch. rraghvani has the right idea. You need to force both values into a string so you know for sure they are the same type. You can use the quotes or something like aqConvert
    
    https://support.smartbear.com/testcomplete/docs/reference/program-objects/aqconvert/index.html
Luukdb
Contributor
9 months ago
Marsha_R I tried the quote idea but this didn't work.

I put the product number directly in the variable and the IF worked. This means that the data from the table isn't seen the same as if I put it directly in the variable.

I wanted to try the aqConvert, but I am not sure what to do in the keyword test.

Do you think aqConvert the table data to a string and put it in ProductID works? Or like I am doing now, put the table data in the variable beforehand and convert that to a string?
rraghvani
Champion Level 3
9 months ago
You can use the method like so (not a great example!),

Also, the value that's stored in your variable may contain a line feed or carriage return character and hence the if..statement is not working as you expect.
Luukdb
Contributor
9 months ago
Thank you. But this is also not working for this product number..

The strange thing is, I ran another test, and here everything works fine. So that means my original code works and your aqConvert works.

Now I am very lost why it doesn't work for this product number but other tests are going fine.
- Marsha_R
  Champion Level 3
  9 months ago
  I'm not clear where you actually did the aqConvert, but it needs to be in your compare, something like
  
  If aqConvert.VarToStr(firstvalue) = aqConvert.VarToStr(secondvalue) then <do stuff>
rraghvani
Champion Level 3
9 months ago
You need to check the input and output format of your product number, is what you expect it to be.

Unless it's a genuine issue (bug) with TC.