Ask a Question

Exception in Keyword testing with Data Base Table variable

SOLVED
bkrishna213
Occasional Contributor

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.

14 REPLIES 14

@bkrishna213 

 

I believe i have found a solution:

ebarbera_0-1638545483427.png

It displays interestingly in TestComplete but it doesnt look like it throws an exception.

ebarbera_1-1638545595627.png

 

Emma

bkrishna213
Occasional Contributor

Hello,

Thank you very much for the workaround.

Checkpoint got passed with General type in excel. 

But the expected result which is customer details cannot be displayed because customer id entered into the application is without 0's. 

 

sonya_m
SmartBear Alumni (Retired)

Thanks everyone for being so helpful!

 

@bkrishna213 are you still looking for a solution? If so, perhaps, opening a support ticket for deeper investigation will be the best next step.


Sonya Mihaljova
Community and Education Specialist

bkrishna213
Occasional Contributor

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.

sonya_m
SmartBear Alumni (Retired)

Thank you so much for sharing the solution! Much appreciated @bkrishna213 !


Sonya Mihaljova
Community and Education Specialist

cancel
Showing results for 
Search instead for 
Did you mean: