Answer / amarendra kothuru

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

Answer / raj

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

Answer / cnu_thatavarthi

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

Use of Debug Viewer?

1 Answers  

---

Is it possible to map an image as standard Object or u've to treat as virtual? how to map an Dynamic image into standard object?

1 Answers  

---

Can any one please explain hwo to test client/server application using QTP?

3 Answers   Patni, Value Labs,

---

how will you handle the situation when object is not caputred during record?

0 Answers  

---

one ok button and one text box is there.when i click on ok button in that text box one no. will display from 1 to 100 randomley.if that is not 100 when we click on ok button again ,again another text box ll created with another no. we will continue this till the text box created and displays 100.and when its 100 ok button should disabled. remember thet no will display not seriely ,it displays randomley,and each time new text box will created.

6 Answers   ADP,

---

Can we use Virtual Objects in Discriptive Programming?

5 Answers   Keane India Ltd,

---

how to get the data from a winedit box in vb scripting and store it in a variable if data contains "_"(i.e data is TEST_1)

3 Answers  

---

Please explain me in detail! How to handle runtime errors in QTP useing recovery senario or with out scenario

5 Answers   Quinnox,

---

1. Can anyone help me with recovery scenarios, each type with examples and also what is on error resume next?

1 Answers  

---

if the excel sheet specified in script is not there,we get run time error how to handle the error ,please anybody explain me in detail

2 Answers   Quinnox,

---

Hi, My problem is as follows. I recorded a script that created Object repository of each action i recorded. But later I added one more step (which was to enter data in a textfield) into the script through expert view. But as no repository for this newly added step exists in the test, my script fails. So please help me to sort this problem that how can I create object repository of a new step in an existing test. Thanks everyone

1 Answers  

---

I'm quite new at QTP. Im doing a web-based app testing. I create something new item and a new link is created in the home page. This link is dynamic as it changes every 3 seconds. Obviously the new link is not in my Object Repo and I am trying to find a way how can I do a check or get the propery of the link I created. I can do it on keyword, but I need to do a check on expert mode, vbscript. I always get an error that is not identified whenever i try to check it (browser(b),page(p).link(newlink). Any idea?

4 Answers  

---