Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Application Program Interviews:AutoCADBEA WeblogicBioinformaticsBizTalk ServerBug Tracking ToolsBugzillaClarify CRMCoding StandardsComputer Aided Design (CAD) DesignerCVSGIMPJMXLINQLoadRunnerMagentoMATLABMicrosoft AccessMicrosoft ExcelMicrosoft OfficeMicrosoft OutlookMicrosoft WordModel View Controller (MVC)OLAPOOADQuickbookRational RobotRDFSchemaSiebelSilkTestSVGTest PlanTesting ToolsUnity 3D DeveloperVRMLWCF SDKWPFXML DOMXPointer
Copyright © 2018. All Rights Reserved
SilkTest Interview Question:
Trying to create a datadriven tests
Submitted by: AdministratorTrying to create a datadriven tests. Placed the .xls file in a data folder. The script should connect to the .xls file, open the file, read the contents in the .xls file and fill the form with the values. I have written some steps using the Help guide. Its not working i get errors Can any one suggest me the list of steps and in which folder these steps should go.
The following error:
C:Program FilesSegueSilkTestexamplesframe .inc(2): Window class BrowserChild is not defined or ambiguous
Database connectivity - Found word(s) list error in the Text body
the following error now:
Error: Variable (frmCompanyName) has not been set
Also I did the variable declaration as follows
[-] testcase DD_Test1 (REC_DATALIST_DD_Test1 rData)
[ ] STRING frmCompanyName
[ ] STRING Phone
[ ] STRING Contact
[ ] STRING Title
[ ] STRING Insights
[ ] STRING CoInsights
This looks like more of a scoping issue in Silktest than a problem with any DB connection to an excel file. Since I am heading out the door in just a few, I will have to take a closer look at this tommorow but typically, my data driven scripts are structured sort of like:
[ ] //this reads the data from the spreadsheet and then iterates
[ ] use "P:Silkauincludesautoarch_temp.inc"
[ ]
[-] main()
[ ] HANDLE hDB
[ ] HANDLE hSQL
[ ] STRING sFirstName, sLastName, sAddress, sEmail, sComment, sExpected, sItem
[ ] INTEGER iCase, iPF, iRun
[ ] LIST OF STRING lsCases
[ ] STRING sQuery = "Select * from `Sheet1$`"
[ ] //open spreadsheet:
[ ] hDB = DB_connect ("DRIVER=Microsoft Excel Driver (*.xls);DBQ=P:QARelease11.1AUAutomationcontact_validation_words11_ 1.xls; READONLY=FALSE")
[ ] hSQL = DB_ExecuteSQL(hDB, sQuery)
[-] while DB_FetchNext(hSQL, iCase, sFirstName, sLastName, sAddress, sEmail, sComment, sExpected, iPF, iRun)
[ ] //print("{iCase} {sFirstName} {sLastName} {sAddress} {sEmail} {iRun}")
[-] if iRun == 1
[ ] ListAppend(lsCases, "{iCase}|{sFirstName}|{sLastName}|{sAddress}|{sEmail}|{sComment}|{sExpec ted}|{iPF}|{iRun}")
[ ]
[ ] DB_FinishSql (hSQL)
[ ]
[-] for each sItem in lsCases
[ ] TestContactInfo(sItem, hDB)
[ ]
[ ]
[ ]
[ ] DB_Disconnect(hDB)
[ ]
//-----------------------------------------------------------
[-] testcase TestContactInfo(STRING sTest, HANDLE hDB optional)
[ ] //logic to feed the functions and methods to run the cases and determine pass/fail.
[ ] //can even write results to the same excel file, if need be.
And of course, there are going to be plenty of people out there with var. setups (plans, suites...)
Submitted by: Administrator
The following error:
C:Program FilesSegueSilkTestexamplesframe .inc(2): Window class BrowserChild is not defined or ambiguous
Database connectivity - Found word(s) list error in the Text body
the following error now:
Error: Variable (frmCompanyName) has not been set
Also I did the variable declaration as follows
[-] testcase DD_Test1 (REC_DATALIST_DD_Test1 rData)
[ ] STRING frmCompanyName
[ ] STRING Phone
[ ] STRING Contact
[ ] STRING Title
[ ] STRING Insights
[ ] STRING CoInsights
This looks like more of a scoping issue in Silktest than a problem with any DB connection to an excel file. Since I am heading out the door in just a few, I will have to take a closer look at this tommorow but typically, my data driven scripts are structured sort of like:
[ ] //this reads the data from the spreadsheet and then iterates
[ ] use "P:Silkauincludesautoarch_temp.inc"
[ ]
[-] main()
[ ] HANDLE hDB
[ ] HANDLE hSQL
[ ] STRING sFirstName, sLastName, sAddress, sEmail, sComment, sExpected, sItem
[ ] INTEGER iCase, iPF, iRun
[ ] LIST OF STRING lsCases
[ ] STRING sQuery = "Select * from `Sheet1$`"
[ ] //open spreadsheet:
[ ] hDB = DB_connect ("DRIVER=Microsoft Excel Driver (*.xls);DBQ=P:QARelease11.1AUAutomationcontact_validation_words11_ 1.xls; READONLY=FALSE")
[ ] hSQL = DB_ExecuteSQL(hDB, sQuery)
[-] while DB_FetchNext(hSQL, iCase, sFirstName, sLastName, sAddress, sEmail, sComment, sExpected, iPF, iRun)
[ ] //print("{iCase} {sFirstName} {sLastName} {sAddress} {sEmail} {iRun}")
[-] if iRun == 1
[ ] ListAppend(lsCases, "{iCase}|{sFirstName}|{sLastName}|{sAddress}|{sEmail}|{sComment}|{sExpec ted}|{iPF}|{iRun}")
[ ]
[ ] DB_FinishSql (hSQL)
[ ]
[-] for each sItem in lsCases
[ ] TestContactInfo(sItem, hDB)
[ ]
[ ]
[ ]
[ ] DB_Disconnect(hDB)
[ ]
//-----------------------------------------------------------
[-] testcase TestContactInfo(STRING sTest, HANDLE hDB optional)
[ ] //logic to feed the functions and methods to run the cases and determine pass/fail.
[ ] //can even write results to the same excel file, if need be.
And of course, there are going to be plenty of people out there with var. setups (plans, suites...)
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.