Forum Discussion

pkudrys's avatar
pkudrys
Contributor
11 months ago

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

Hi folks,  I want to pass a Table Variable to my custom function and obtain value from defined row number and column name.  At first, I tried to follow the sample code from TC User Guide:  https:/...
Variables
  • rraghvani's avatar
    rraghvani
    11 months ago

    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's avatar
rraghvani
Champion Level 3
11 months ago

It's good to see someone using the Watch List and trying to diagnose the issue 🤖 

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. 

  • pkudrys's avatar
    pkudrys
    Contributor
    11 months ago

    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.