(JavaScript) Unable to get value(s) from TableVariable passed to a function

Question

Hi folks,&nbsp;I want to pass a Table Variable to my custom function and obtain value from defined row number and column name.&nbsp;At first, I tried to follow the sample code from TC User Guide:&nbsp;https://support.smartbear.com/testcomplete/docs/reference/program-objects/tablevariable/index.htmlBut the sample fails at Iterator.Reset(); line with "cannot read property" error...But the problem seems to be at previous line MyIterator = MyVar.Iterator; which does not return Iterator object, although the MyVar successfully loads Table variable "steps".I also renamed the&nbsp;Iterator variable to MyIterator, just to make sure it does not interfere with Iterator property, but no luck either.Does anyone have an idea what's wrong? Is there something missing, the sample code is obsolete or I found a bug? Thank you in advance.BTW, is there a way to get the value from table variable via column name/row index?&nbsp;

rraghvani · Accepted Answer

MyVar is an Object, that just contains ColumnCount and nothing else. It should also contain TableVariable Object Properties. This is the reason why Reset fails, as there's no Iterator.
You need to check this,

to ensure it's returning the correct object type.

rraghvani · Answer

It's good to see someone using the Watch List and trying to diagnose the issue 🤖&nbsp;
To diagnose an issue, try to work backwards, from where you think the issue is occurring (line 43), and you will have more of a chance in solving the problem.&nbsp;

pkudrys · Answer

The Watch is definitely a useful tool and I can't imagine debugging problems without it. But this time, I would most probably not realize the cause of the problem myself. I'm still too inexperienced with the TC and what it actually shows in the watch.BTW, I just used the proper DB Table code and after loading DB Table to the variable, it shows just ColumnCount in the Watch and nothing else. But this time, Reset worked as expected and I was able to extract all available data :)In fact, the original code works with the DB Table as well. It just required removing the Iterator Property and that was it. I think it would be good to unify the Table and DB Table properties and methods.&nbsp;

rraghvani · Answer

You're assigning MyIterator = MyVar.Iterator. What is the type and the value of MyVar?

pkudrys · Answer

MyVar contains Table variable, defined in Keyword test. If you check the second screenshot, you can see it shows ColumnCount=1 so the MyVar appears to by correctly filled with Table object.

The problem is, that MyVar.Iterator returns "nothing". But according to the user guide, Iterator property should return Iterator object, which provides a scripting interface to rows of the array.

pkudrys · Answer

Thank you for your hint! I found the cause of the problem. The variable I created was DB Table, using CSV file and it's not compatible with the above code. Silly me :) The sample code from this page works as expected:

https://support.smartbear.com/testcomplete/docs/reference/program-objects/dbtablevar

Forum Discussion

(JavaScript) Unable to get value(s) from TableVariable passed to a function

6 Replies

Related Content

Variable declaration in a javascript class

javascript try/catch block

Copy and rename a file using JavaScript

Calling JavaScript Classes from other files

Parsing JSON data in Javascript

Recent Discussions

Inspecting a DotNetBrowser Chromium control

Dynamic Object

Pulling in Dynamic Links from a web page

Multiple execution of a test plan with different values from an Excel table

Your thoughts about a REST API in TestComplete