Forum Discussion

bkrishna213's avatar
bkrishna213
Occasional Contributor
4 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 throwing exception when i am passing 000 via excel.

Example: customer id is 00000088 . In the excel the field type is Text. 

Declared as below in test complete. 

bkrishna213_0-1638453679675.png

Can you please help me how to make this test accept text type as input from excel.

data-driven testing
keyword tests
test run
  • bkrishna213's avatar
    bkrishna213
    4 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.

14 Replies

  • ebarbera's avatar
    ebarbera
    Icon for Staff rankStaff
    4 years ago

    Hello bkrishna213 - 

     

    What is the step in your test that is throwing the exception? Is it a checkpoint? Please show how it is configured.

     

    Thanks, 
    Emma

    • bkrishna213's avatar
      bkrishna213
      Occasional Contributor
      4 years ago

      Step where entering customer id

      bkrishna213_4-1638457693051.png

       

       

      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"]

      bkrishna213_1-1638457563554.png

       

      Excel is having below columns

      bkrishna213_2-1638457563554.png

       

      • Marsha_R's avatar
        Marsha_R
        Icon for Champion Level 3 rankChampion Level 3
        4 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.

  • mattb's avatar
    mattb
    Icon for Staff rankStaff
    4 years ago

    Hi,

    Could you take a screenshot of the keyword test or code you are running that's failing? 

    • bkrishna213's avatar
      bkrishna213
      Occasional Contributor
      4 years ago

      The entire test is based on Property check point comparison.

      And its a data driven loop keyword test. The comparison is passed for when excel cell data type is integer Ex: 8900000.

      I converted to text local excel cell to text to accept 0's. When this cell hit test complete then exception is thrown.

      Please check the attachment.

      Thank you.