missydr
Occasional Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Running a query on Excel sheet coming back with no values
I was making it harder than it needed to be.....of course! Here's the working script. function ReadDataFromExcel() { var myDate = "5/31/2000"; var myDesc = "FLAT FEE"; var myDriver = DDT.ExcelDriver("C:\\IUL_Calc.xlsm", "Activity"); do { myDriver.ADOCommandObject.CommandText = 'SELECT * FROM [Activity$]'; if (aqConvert.DateTimeToStr(myDriver.Value("Date"))== myDate) { Log.Message(myDriver.Value("Date")); if((myDriver.Value("Description"))== myDesc) { Log.Message(myDriver.Value("Description")); Log.Message(aqConvert.CurrencyToStr(myDriver.Value("Amount"))); break; } myDriver.Next(); } }while (! myDriver.EOF()) DDT.CloseDriver(myDriver.Name); }1.8KViews1like1CommentRe: Running a query on Excel sheet coming back with no values
Marsha_R I had been breaking it down and was still getting errors. tristaanogre I had tried it as Log.Message(myDriver.Value(0)) and received an "Data type mismatch in criteria expression" error. So the way I had it was the only way I wasn't getting an error. It makes sense to me to put Value(0) but with the error I was getting....I was getting desperate! :) I got it to finally work after commenting out "where [Date] = "6/30/2000" AND [Description] = "FLAT FEE"' and adding the loop. I don't need every amount just the amount on the specific date. Will TestComplete let me do that? Do I just need to break the query down more in my code to get the value I want?1.8KViews0likes3CommentsRunning a query on Excel sheet coming back with no values
I'm trying to pull a specific value from an Excel sheet by using a query but I get back nothing in my log. I've spent too much time already trying to get it to work. See the script below that I created. Any help will be much appreciated. function ReadDataFromExcel() { var myDriver = DDT.ExcelDriver("C:\\IUL_Calc.xlsm", "Activity"); myDriver.ADOCommandObject.CommandText = 'SELECT [Amount] FROM [Activity$] where [Date] = "6/30/2000" AND [Description] = "FLAT FEE"'; Log.Message(myDriver); DDT.CloseDriver(myDriver.Name); } MissySolved1.9KViews0likes7CommentsRe: Processing commands super slow
While I've been trying to update the Name Mapping, the issue has made almost everything painfully slow. Running test executions, however, run at normal speed. It's only seems to be slow while I'm updating the Name Mapping, recording scripts, or just adding a new object or it's children. Robert, is that the same functionality you are seeing while you are updating your name mappings?1.9KViews0likes1CommentProcessing commands super slow
On Friday, after I was done recording a keyword script, the Processing Commands message was shown for over an hour and still did not create the script. Today, I recorded only a couple clicks but the message showed for over half an hour and did not create the script. I've tried disabling "Search for visible objects first" and disabling "Use extended find when possible" in the Name Mapping options. I've also re-booted the VM machine that TC is on. Nothing is working so far.Solved2KViews0likes7Comments