did you perform retesting(DATA DRIVEN test) using functions
with out using datatable methods
how can you perform retesting using functions
Answers were Sorted based on User's Feedback
Generally, QTP exports uses Excel file for data
paramaterization.
Method 1)Prepare test data in Excel sheet and import into
QTP data table. Using DataTable methods, user can easily
parameterize data and access them through out the script.
DaTaTable Methods: Import, ImportSheet, Export,
ExportSheet, GetSheet, SetCurrentRow, SetNextRow etc...
E.g:
DataTable.Import "Excel file path"
testData = DataTable(columnName, Sheetname)
(or)
testData = DataTable(columnName, dtGlobalSheet)
Method 2)Prepare test data in Excel sheet. Instead of
importing Excel file/sheet into Test script, create an
Excel object in the script using CreateObject method. Using
Excel object methods user can able access data from excel
sheet.
E.g:
Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.WorkBooks.Open "Excel file path", false, false
Set currentWorkSheet = ExcelObj.ActiveWorkBook.WorkSheets
(1) 'first sheet
testData = currentWorkSheet.Cells(rownumber,
columnnumber).Value
ExcelObj.Application.Quit
Is This Answer Correct ? | 2 Yes | 0 No |
May be solution i'm providing is not a DataDriven but it is
useful.
We can access the object property at runtime and then append
something in the property and then again insert into the object.
Like we have a text box amount having value = 10
So we can use
value1 =
Browser(".*").Page(".*").WebEdit("amount").GetroProperty("value")
value1 = value1 + 1
Browser(".*").Page(".*").WebEdit("amount").Set value1
Is This Answer Correct ? | 0 Yes | 0 No |
Question:did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods.
Answer: With out using datatables we can do the retersting using below methods
1. File System objects(Using note page)
2. Database connections(SQL, Oracle, MS Access)
3. Environment variables
4. Random numbers, Excel methods, Inputbox
5. Parameters(Actions and Test Parameters)...ETC
Is This Answer Correct ? | 0 Yes | 0 No |
Analyzing the Checkpoint results ?
What is an Regular expression doing in VBScript?Tell the pattern for the email verification.
is qtp 9.2 create the scripts with the application run on mozilla firefox browser?
What is parameterization? What is syncronization pt.?
3 Answers Semantic Space, SRM,
Reverse a string keeping the words in the string as it is. E.G. "Quick Test Professional" O/P "Professional Test Quick"
how can i add an action(external action) programmatically?
What are Add-ins availble in licensed version QTP8.2
How we can add actions in the test using QTP?
wt is the use of multiple questions in QTP
your coming from electrical backgroung..but y ur coming to software side?
HI All i need one suggestion.is there any companies taking corresponding degree courses. i have 3+ yrs exp in QTP and i am working north side. iam looking for job in south.
If the object property is changing very frequently, what was your approach?