Forum Discussion

bkrishna213's avatar
bkrishna213
Occasional Contributor
5 years ago
Solved

Exception in Keyword testing with Data Base Table variable

Hello,   I am trying to compare excel data with desktop application. Passing inputs from my local excel. Created variable in project level and assigned related excel cells. Test complete is throwi...
data-driven testing
keyword tests
test run
  • bkrishna213's avatar
    bkrishna213
    5 years ago

    Hi,

     

    I found the solution finally. The working solution is passing all fields data type as text to testcomplete. 

    Will close this thread. Thank you.

bkrishna213's avatar
bkrishna213
Occasional Contributor
5 years ago

Step where entering customer id

 

 

Onscreen action for settext. Here CustomerId is the one which I am picking from excel.

Expected is this step need to enter 0000008 in edit field. But once the control comes here exception is thrown.

KeywordTests.Customer_Inquiry_DataLoop.Variables.Cust_inq["CustomerId"]

 

Excel is having below columns

 

Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
5 years ago

Over the years I've been using TestComplete, I would run into this problem, and others, using Excel as a data source.  I was spending a lot of time trying to compensate for what are just innate properties of Excel itself.  When I switched to using .csv files for my data source, my test development got much easier.