Contributions
Re: How to Execute a Stored Procedure from within a Test.
Thanks Steve, that was helpful. I did notice that the code was slightly different than what was given in an earlier post. (Steve if you could give reasons for using ADOCommand vs ADOCreateStoredProcedure objects?) One of the things that was suggested was to put in a 'wait' for the process to complete. My question is will the test continue once the procedure is finished or wait the full 'wait time' before continuing. EX: If the procedure takes 2 min run, and I have set the wait time to 5 min, a) Will the test continue after 2 min, when the procedure completes? b) Will the test wait the ful 5 min before continuing? I would like the test to continue once the procedure completes. There is no return values from the procedure to validate against.667Views0likes0CommentsRe: How to Execute a Stored Procedure from within a Test.
I noticed that after the comment above. When I tried to add a parameter for 'output' the system said the procedure did not have any parameters. I have subsequently changed the Log line. Also note that the error is failing on the line before the Log line- the SProc.ExecProc; However, my issue still remains. For example if the Log line is commented out, I still receive the same error. Adding Parameters does not fix my issue. Other thoughts?3.4KViews0likes0CommentsRe: How to Execute a Stored Procedure from within a Test.
Given your example I have the following code: SProc = ADO.CreateADOStoredProc(); SProc.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CEA_NEIC;Data Source=<IP Address>"; SProc.ProcedureName = "CEA_NEIC.dbo.P_update_RPT_PI_Profile_Summary_Data_job"; SProc.ExecProc(); Log.Message("Result: " + SProc.Parameters.Items(1).Value); and the test fails with a "JScript Runtime Error" andthe following: Query timeout expired Unit: "Create_New_PI" Line: 25 Column: 3. where line: 25 Column: 3 is the "SProc.ExecProc()'" line above. Any help here? Do I have to increase the timeout value for queries or something? The actual Stored Procedure runs about 2min3.4KViews0likes0CommentsRe: Importing Projects/Suites/Tests from the network
I am reading the Help that you suggested I look at. However this paragraph suggests that this will not be useful: When you add a project to source control from TestComplete, the latter saves the local file paths to the project (or project suite) files. If you check out the project (or project suite) using TestComplete on another computer, TestComplete will replace the local paths in the project (project suite) file with the paths relevant to this computer, so when you open the project on your computer again, the project link to source control will be broken and you will have to rebind the project to source control. If I am reading this correctly, with many people checking out the project (saved in Source Control) my project will continue to keep breaking and I will have to continually 'rebind' it. This doesn't sound very 'user friendly'.1KViews0likes0CommentsImporting Projects/Suites/Tests from the network
Hi, I would like to be able to put all the tests I create out on our company shared network, and then have those who need to run the tests import (pull down from the network) into their Test Complete and run the tests. This way there is one master copy of the tests, and anyone can pull and run whatever tests they want. Is this possible? If so, how does one do this? Also would be nice to configure my TC to automatically save in the network location so I don't have to copy from my local dir to the network. Thanks for your help.11KViews0likes4CommentsRe: InnerText not enough to distinguish between 2 links
Thanks again for the information. However, I'm still confused. I did find where you are talking about I have 2 links the same. One is in the 'header' section of the page, and one is in the body of the page. You said earlier that if the objects are at the 'same level' (I assume this is refering to the level in the object tree) that this issue arises. However, if you look at my tree structure (See attached image), the links in question are not. The 'linkAdvancedSearch' (in green) in the page body ('Nav' in blue)is at the same level as the 'Search' link, but has different 'innerText'. The 'linkAdvancedSearch'(in green) in the header ('pHeader' in blue), while has the same 'innerText', it is at a 'different level' than the one in the page body. Could you point out what I am missing or not understanding correctly? Thanks.5.4KViews0likes0CommentsRenaming Aliases does not update test code (script)
I noticed in the help it says that if you have 'keyword' test in your project that TC will offer to update your tests when you rename an alias name. This does not seem to apply to 'script' tests. Is there a way to update script test code when aliases are renamed?11KViews0likes3Comments