Raymondtailor
Occasional Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Unable to load URL from Excel in Test Complete
Working on Test Complete Keyword driven framework, which is now migrated from Win7 to Win10. All the environment URLs configuration are in Excel sheet. Issue: During execution once the browser launched URL is not opening Debug: While debugging found one error . MyCCPay Portal Error: Operation is not allowed when the object is closed. Below is the code to read from Excel: Function GetXLSRecordset(strFilePath, strSQL) On Error Resume next Set objConnection = CreateObject("ADODB.Connection") 'Create Connection srting strConnectionstring = "Provider=Microsoft.ACE.OLEDB.16.0;" & _ "Data Source=" & strFilePath & ";" & _ "Extended Properties=Excel 16.0" Log.Enabled = True Log.Message(strFilePath&"::"&strSQL) objConnection.Connectionstring = strConnectionstring 'Open connection for assgined connection string objConnection.Open 'Create new recordset Set objRecordset = CreateObject("ADODB.Recordset") 'Execute SQL Query objRecordset.Open strSQL, objConnection, adOpenStatic, adLockReadOnly record_Count = objRecordset.RecordCount Log.Message("Record Count: "&record_Count) Log.Enabled = True Set GetXLSRecordset = objRecordset objRecordset.Close Set objRecordset = Nothing objConnection.Close Set objConnection = Nothing End Function System Configuration: TestComplete 14.x 32bit MS Excel 16.x 32bit MS Access DB driver 16.x 32 bit OS Win 10 Every time I'll try to print objRecordset getting undefined, but it returns the count objRecordset.RecordCount Tried all the possible solution found on community support but didn't work, please suggest me some workaround. Everything is working properly on win7 machine.SolvedI just want to know Is there a way in Testcomplete to efficiently compare two test log files?
I have two TestComplete log files of different runs of the same test script, both contain some errors in it. The test script's code has been changed slightly between the runs. Probably the application behaves correctly and the test script is wrong, so I want to compare the two log files side-by-side to figure out how could I correct the script. When the first log is open and I open the second one, it opens in the same window the first was open in, though. Having to switch between the logs is cumbersome and makes my work too slow. I am aware of the option to export the log files and view them in my browser, but then I would lose some editor features such as clicking on a line in the log file to jump to the adherent code in the test script. I am specifically looking for an option to do it in the editor. Is there a way to compare the two log files in the TC editor by having them show up at the same time side-by-side, in two windows? DinarRecaps.com491Views0likes1CommentHow to scroll to a particular co-ordinate in Test Complete
I have spied a notepad and text box of a notepad contains a string which will be visible only if you scroll down. Now I am trying to perform a single click there via passing a rectangle co-ordinate to the Test Complete.So with that it is able to click if it is visible on the screen otherwise it fails saying :"there was an attempt to perform an action at a point which is beyond the screen" Is there any way where we can scroll to the point of interaction before performing the action. I tried with following steps to achieve that but its of no help. official website testObj.setFocus() testObj.hover() testObject.MouseWheelScroll(an integer value)781Views1like2CommentsI am facing a Cross browser tool It's having slowness issue
I am using test complete as a automation development tool and I need to execute the code in the cross browser tool (CBT). I am experiencing a significant slowness in CBT execution. All tests are failing. Appreciate that you can help me to resolve this issue. FaceTime347Views0likes1CommentI want know How to add custom javaScript library in testcomplete for scripting?
I want to use different libraries of JavaScript in TestComplete for scripting. I was doing API testing using JavaScript code there I didn't found any way to import Other JavaScript library. The use of "import" directly is not working. official website845Views0likes1Comment