Contributions
Re: Objects in an Alias keep changing every TestRun, how can I point directly to an object?
Tank you, using wildcards will be helpfull in many cases for me, The parts that may lead to other screens, or objects I wil leave the given numer, but there are parts where I am sure I will get the correct object if I use a wildcard.1.2KViews0likes0CommentsObjects in an Alias keep changing every TestRun, how can I point directly to an object?
I have a problem when replaying recorded scripts. If I rerun the script on the same application (version) Objects change, which results in the script giving an error because the object cannot be found. Example: Call Aliases.Applic3.FO_CRMMain. StdForm.UO_RelLst.splitContainerControl3.SplitGroupPanel2.tabEigenschappen.tabBereikbaarheid. labelControl7. textBoxUsrNm.SetText(usrCredentials) - Applic3 - splitContainerControl3 - SplitGroupPanel2 - labelControl7 Can differ every run, for example Applic3 becomes Applic and labelControl7 becomes labelControl4 Every time the script executions stops and asks if I want to update the object another time if want to retry. Is there a way I can handle those changes? For me this is an impediment on reusing created scripts, this problem occurs if I rerun in the same application version and even more if I update the application to another version. I see other issues of this kind where the user is advised to Map to the desired object, but my I think My problem will remain, because if I Map the previous Alias to a new mapping, the underlying alias stays valid. My bottom question is, is there a way to point to objects in a way they always will be found from my VB test scripts? Herbert1.3KViews0likes3CommentsRe: Can I push a set of lines to execute in SQL instead of line by line
Thank you Tanya for your answer. I already thaougt about this. But cound find a way to do this. We want to simulate the load to SQL from our application, and therefore I need to do it this way. But 'Can't be done' is also an answer and maybe it is the most clear answer of all. We are arleady searching for other tools where we can do this kind of testing.1.4KViews0likes1CommentRe: Can I run different testsScripts simultaneously
Thank you, this is differt aproch, So Insted of creating one Project with all scripts I create multiple Projects with scripts. In our case all projects wil contain the same scripts, at least the scripts that have to run simultainously. All other scripts wil only apear in the "Main" project. Next step is to distribute every Project to its own Test Machine and run it All Test machines use the same SQL Server. But as befits a good tester There is no solution without a new problem ;-) I have to simulate 1500 Users who aproach the SQL database, so with this solution I need 1500 (virtual) machines to do the test. But is as a good solution, for a lot of my simultainiously testing, I do not have to test with so many users al the time, and then this is a very good solution. Because I do not only simulate the load from different users, there are realy different users.1.4KViews0likes0CommentsRe: Can I run different testsScripts simultaneously
I am not sure yet, I am still strugling with this, reading the explanation, this is what I want but.... I have created several VB scripts in TestComplet whith I want to run. I created a "Control" script, where I can call the seperate script with theis function, but what do I use as Obj and Property name For Example the Scripts called Unit1, Unit2 and Unit3 Within thos scripts I called my Sub routines Test1, Test2 and Test3. I do not need parameters to run the scriptss But my Script is not an object and my subroutines are not methods therefore the line Set Result=Runner.CallObjectMethodAsync(Unit2, "Test1") returns an error "Parameter is incorect" Do I have to create Objects for my scripts and If yes How, or is this the wrong aproach and should I use this sollution differently.1.4KViews0likes0CommentsCan I push a set of lines to execute in SQL instead of line by line
I Use VB Script I recorded a trace file using the SQL profiler. This gives me all "exec ...." (stored) procedures that are executed by my desktop application. Now I want to reuse tose lines so I can simulate the load without using the desktop client of the application But as far as I found out now, I only can execute those lines one by one Sub Test1() Dim arrTraceLine(4), numCount Set aTable = ADO.CreateADOQuery aTable.ConnectionString = "<Connection String>" arrTraceLine(0)= "exec dbo.<SP_Name1> @a_field1=N'100',@a_field2_t=N'9999999999',@a_field3_v=N''" arrTraceLine(1)= "exec dbo.<SP_Name2> @a_field1=100,@a_field2=212102,@a_field3_t=N'9999'" arrTraceLine(2)= "exec dba.<DB_Name3> @field1=100,@field2=NULL,@field3=NULL,@field4=N'1" arrTraceLine(3)= "exec dbo.<SP_Name3> @a_field1=1,@a_field2=87,@a_field3=N'',@a_field4=2" For numCount = 0 to 3 aTable.SQL = arrTraceLine(numCount) aTable.ExecSQL Next End Sub In this Case I would prefer to push the TraceLines as one complete batch For Example aTable.SQL = "exec dbo.<SP_Name1> @a_field1=N'100',@a_field2_t=N'9999999999',@a_field3_v=N'' " &_ "exec dbo.<SP_Name2> @a_field1=100,@a_field2=212102,@a_field3_t=N'9999'" &_ "exec dba.<DB_Name3> @field1=100,@field2=NULL,@field3=NULL,@field4=N'1" &_ "exec dbo.<SP_Name3> @a_field1=1,@a_field2=87,@a_field3=N'',@a_field4=2" atable.ExecuteSQL This way I hope for a more readable Trace as result. I think I need another option for ADO.CreateADOQueryBut What do I fhave to use. I also triedADO.CreateADOStoredProc But I have to split up each parameter in name, type and value this makes the script not very readable. Can someone help meSolved1.5KViews0likes3CommentsCan I run different testsScripts simultaneously
I created several tests to interact with a SQL database. For Example: Script 1 represents UserA who creates a new Customer in the database Script 2 represents UserB who also creates a new Customer in the database Script 3 represents UserC whocreates a new Orderin the database Now I want to simulate a WorkLoad situation to measure performance, therefore I want to run thos TestScripts simultaneously But Al I can do is run them in line. Is there a way to run several scriptsat the same time?1.5KViews0likes4CommentsCan I retrieve the Computername from the System environment
When executing a test I also want to register on witch environment the test was run. So I need the Computername of my machie. Is there a possibility to retrevie this value in VB. I already tried adefault solutions as: Declare Function GetComputerNameA Lib "kernel32" (ByVal lpBuffer As String, nSize As Long) As Long Public Function GetComputerName() As String Dim sResult As String * 255 GetComputerNameA sResult, 255 GetComputerName = Left$(sResult, InStr(sResult, Chr$(0)) - 1) End Function But I cannot Declare Functions in TestComplete. Is there another wayto retrieve this kind of System variablesSolved2.1KViews0likes3Comments