Contributions
Error is displayed while saving project after updating the name mapping file
Description: Error "out of memory while expanding the memory stream" is being displayed while saving project after adding few objects to name mapping. Map few new objects using TC & save the project. Error mentioned in the attached doc is displayed. The size of the name mapping file is about 115 MB. TC version : version 8.0.290.7 Type of the application: WCF/WPF dot net application12KViews0likes1CommentRequirement to read data from the excel tables with multiple rows.
We are using below functions to read data from excel & store it in dictionary objects as key-value pair. It works for the data in Table1(attached file Table) , we get the resulst as "David" But it does not work for Table2(attached file Table2 ).For Table2 ,it displays error "Key is already associated with an element in this collection" Can someone help? Dim sAutomationPath sAutomationPath sAutomationPath = "d:\TC Sample Projects\Excel_MultipleRows\" 'Fetching values from excel tables Function ConnectDB ConnectDB Set AConnection = ADO.CreateADOConnection Dim sConnectionString sConnectionString = _ "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" & _ "DriverId=790;" & _ "Dbq=" + sAutomationPath + "myFile.xlsx;" & _ "DefaultDir=" + sAutomationPath AConnection.ConnectionString = sConnectionString AConnection.LoginPrompt = False AConnection.Open Set ConnectDB = AConnection End Function '******************************************************************** Function FetchDB (sTableName, sSheetName) FetchDB (sTableName, sSheetName) Dim iIndex 'Get ADO Connection Object Set AConnection = ConnectDB () Set Driver = DDT.ExcelDriver(sAutomationPath + "myFile.xlsx", sSheetName,true) Set RecSet = AConnection.Execute_("SELECT * FROM "+ sTableName) Set objDict = CreateObject("Scripting.Dictionary") RecSet.MoveFirst While Not RecSet.EOF for iIndex = 0 to Driver.ColumnCount-1 objDict.Add (Driver.ColumnName(iIndex)), RecSet.Fields(Driver.ColumnName(iIndex)).Value Next RecSet.MoveNext WEnd Call DDT.CloseDriver(Driver.Name) Set FetchDB = objDict End Function '******************************************************************** Sub Test1 Test1 Set dictObj = FetchDB ("Table1","Sheet1") Log.message (dictObj.item("EmpName")) .message (dictObj.item("EmpName")) End Sub Result1: David Sub Test2 Set dictObj = FetchDB ("Table2","Sheet1") Log.message (dictObj.item("EmpName")) .message (dictObj.item("EmpName")) End Sub Result2: Error_Test2 file attached Excel table: screenshot of the excek table data is attached.19KViews0likes2CommentsCan we execute the update sql queries and select statements with where clause?
We have requirement to run few update queries using the Testcomplete tool by connecting to SQL Db. We have tried select sql statements which does work. But not very sure about the update sql statement to manipulate the data in table.Can someone help?14KViews0likes2CommentsWPF objects are not getting recognized in the TC version 7.52.678.7
Tried to check the object properties of the Login page of our application developed in WPF. But the text fields such as Client ID,username ,password etc are not getting recognized using TC ver7.52.678.7.But with TC ver 7.50.653.7 the objects are getting recognized. what could be the reason for this behaviour?Is it something to do with version incompatibility. object property for Client ID text field using ver 7.50.653.7 Sys.Process("IEXPLORE").IEFrame(0).Tab("http://clesxwin12/intuit.ires.framework.ui/Intuit.IRES.Framework.UI.xbap?Service=https://clesxw - Windows Internet Explorer").Window("Shell DocObject View", "", 1).Window("DocObject_Top_Class", "", 1).WPFObject("HwndSource: RootBrowserWindow", "").WPFObject("RootBrowserWindow", "", 1).WPFObject("Desktop", "", 1).WPFObject("Grid", "", 1).WPFObject("Login", "", 1).WPFObject("pageGrid").WPFObject("logonGrid").WPFObject("userEntryGrid").WPFObject("txtClientID") object property using ver 7.50.653.7 Sys.Process("IEXPLORE").IEFrame(0).Window("Frame Tab", "", 1).Tab("http://clesxwin12/intuit.ires.framework.ui/Intuit.IRES.Framework.UI.xbap?Service=https://clesxw - Windows Internet Explorer").Window("Shell DocObject View", "", 1).Window("DocObject_Top_Class", "", 1).Window("HwndWrapper[http://clesxwin12/intuit.ires.framework.ui/Intuit.IRES.Framework.UI.xbap#Intuit.IRES.Framework.UI.xbap, Version=5.2.374.0, Cultu;;c0ae89f6-aa1a-4c8e-a0d4-cdecf42ae4e0]", "", 1)14KViews0likes1CommentUnable to split the string using Chr(150)
Trying to spilt the string using Chr(150) which is ASCI representation of "-". But below error is displayed. Sub SplitDemo2 SplitDemo2 Dim s, ss s = "May 26 - June 25" ' Split at line break character. ss = Split(s, Chr(150)) Log.Message("There are " & (UBound(ss)+1) & " words in the array") Log.Message("The first word is: " & ss(0)) Log.Message("The first word is: " & ss(1)) End Sub Result An exception occurred in the "FS_OnlineLease" unit at line 854: Microsoft VBScript runtime error Subscript out of range: '[number: 1]'12KViews0likes2CommentsRe: Mozilla browser support
Thanks for the info on mozilla firefox3.6. Which version of the mozilla firefox is supported by testcomplete? We have also requirement of browser compatibility testing of web application using Test Complete. Please let me know if Test Complete supports the below mentioned browsers .If exist for what versions of these browsers are supported. 1.Google Chrome 2.Apple Safari 3.Netscape895Views0likes0Comments