Contributions
How to get a stored procedure results?
Hi, I need to execute a stored procedure - dbo.GetOrderAndBillingContacts which has only one input parameter an no out parameter. After executing this SP in SQL , i am getting results from two tables in two rows. I have followed your 'Call an SQL Stored Procedure' and i didn't get appropriate results. Please help how to proceed? function Test() { var SProc; SProc = ADO.CreateADOStoredProc(); SProc.ConnectionString = "Provider=SQLOLEDB;Persist Security Info=True;User ID=mossdev;Password=M1sadm1n;Initial Catalog=mis;Data Source=CSSBEDTESTSQL"; SProc.ProcedureName = "dbo.GetOrderAndBillingContacts"; // Adding an in parameter: SProc.Parameters.AddParameter(); SProc.Parameters.Items(0).name = "IntCustomerId"; SProc.Parameters.Items(0).DataType = adSmallInt; SProc.Parameters.Items(0).Size = 32; SProc.Parameters.Items(0).Value = 5052; // Running the procedure SProc.ExecProc(); // Obtaining the return value Log.Message("Result: " + SProc.Parameters.Items(0).Value); }13KViews0likes1CommentHow to verify the displayed search results are satisfying the search criteria.
Hi, I need to verify that the displayed search results are satisfying the search criteria. Here the Link is child of panel. Attached screenshot. Please help me how to get the name of each link? Many Thanks, Kish12KViews0likes5CommentsRe: i need to click on a link in the cell for specific condition satisfies?
Hi, Thanks for your quick reply. I have tried , but TC is not clicking on the link in the cell. Attached the correct screenshot this time. function CancelInvoice() { //Runner.CallMethod("AmendInvoice.AmendInvoice"); var invoicetable = NameMapping.Sys.IEXPLORE.pageCustomerrenewaldetails.panelMsDlgcontent_2.panelMsDlgborder.panelMsDlgframecontainer.frameDlgframecc7178db6cb84d9880b.formAspnetform.panelS4Workspace.panelS4Bodycontainer.panelS4Mainarea.panelMsoContenttable.panelS4Ba.panelMsBodyareacell.panelCtl00MsoContentdiv.panelContainer.panelOrderdetailszone.table.cellMsozonecellWebpartctl00MG65f.tableS4Wptoptable.cell.panelWebpartctl00MG65f23335Bacc4.panelCtl00MG65f23335Bacc48199973.panelCtl00MG65f23335Bacc48199973.panelCtl00MG65f23335Bacc48199973.panelCtl00MG65f23335Bacc48199973.panelCtl00MG65f23335Bacc48199973.panelCtl00MG65f23335Bacc48199973.tableCtl00MG65f23335Bacc48199973; var count = invoicetable.RowCount; Log.Message(count); if(count>1) { for(i=0; i<(invoicetable.rows.length)-1; i++) { Log.Message(invoicetable.rows.length); for (j = 0; j < invoicetable.rows.item(i).cells.length; j++) { Log.Message("Cell " + j + ": " + invoicetable.rows.item(i).cells(j).innerText); var x = invoicetable.FindChild("innerText", "View", 1); y = x.Parent; if(y.Exists) { y.Click(); } } } } checked Additional information in the log. 'A click at point (493, 29) with no key pressed' is displayed.2.6KViews0likes0Commentsi need to click on a link in the cell for specific condition satisfies?
Hi, I have to write a Jscript for the below condition. click on 'View' link when the status = Invoice Pending. for other status it should not click on the link. The ObjectType is table. Attached the screenshot. Pls help? Thanks and Regards, Kish19KViews0likes6CommentsHow to click on a label/link exist in a row?
Hi, I have written a script to click on a link exist in each row (first column entry) in a table. Attached the screen shot. If i run this script , it is always selecting the first entry. Kindly suggest any changes to my script? function orderdetails(y) { var j; order = Aliases.IEXPLORE.pageCustomerorderdetails.panelCtl00MG8b2deec601ca48898630_1.tableCtl00MG8b2deec601ca48898630; var ordercount = order.RowCount-1; Log.Message(ordercount); for(j=1; j<=ordercount; j++) { Log.Message(j); orderslink = order.cell(j, 0); Log.Message(y); Log.Message(orderslink.innerText); if((orderslink.innerText)== "Test 1") { var PropArray, ValuesArray, w; PropArray = new Array("innerText"); ValuesArray = new Array("Test 1"); w = orderslink.FindChild(PropArray, ValuesArray, 5); Delay(3000); w.Click(); Aliases.IEXPLORE.pageCustomerorderdetails.linkClose.Click(); Delay(3000); } } } Many Thanks, Kish9.4KViews0likes3Comments