Contributions
Unable to store correct value returned from database select query
Hi, I'll try to explain the problem with as much detail as possible. In summary I'm trying to read a value from the db and use it in my scripts. I created a db table variable using database query, query select is "select FIRST 1 ORDER_ID from ORDERS ORDER by ORDER_TIME desc" When I view the result from the edit DB table variable value, it returns correct expected number which is a numeric value as per the DB schema. but when I try to read this value in my code usinglastOrderID = Project.Variables.OrderID.Value["ORDER_ID"], I get this value which is alpha numeric with decimals in it. This is what I get when I try to add database table checkpoint Can someone help me identify what's wrong here? I have tried retrieving this value using direct script, creating a db table variable and using db query and finally using datatable table checkpoint wizard. No success so far.Solved728Views0likes1CommentUnable to load excel to read test input data
Hi, I'm very new to test complete. As part of my test scenario, I'm trying to open an excel and iterate over various columns in in form of a while loop. While creating test data, I read somewhere we don't need to have MS excel to be able to do it but I'm getting this exception below. To provide more background, I'm doing this on a virtual machine where there is no MS Excel installed. The excel file is valid.Solved591Views0likes1Comment