Exception in Keyword testing with Data Base Table variable

[bkrishna213]

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. 

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

[ebarbera]

@bkrishna213 

I believe i have found a solution:

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

Emma

[bkrishna213]

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]

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.

[bkrishna213 · Accepted solution]

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]

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