Answer Posted / naga chiranjeevi kota

Session="mysession";


connstring="DSN=DQMCHIRU;UID=dqm5map;pwd=dqm5map;server=Orcl";
rc=db_connect(Session,connstring);

x="select PART_NUM,PART_ORG ,RDX_ID,DESCRIPTION from
reference_data_part where part_num like '%31' order by
PART_NUM";
printf(x);

# Opening the excel sheet
dqmdata = "C:\ExecuteSampleData.xls";
rc = ddt_open(dqmdata, DDT_MODE_READWRITE);
if (rc!= E_OK && rc != E_FILE_OPEN)
pause("Cannot open table.");

dc=db_execute_query(Session,x,rows);

#ddt_get_row_count(dqmdata,rows);
for(i=0;i<rows;i++)
{
db_get_row(Session,i,rowcon);
#ddt_set_row(dqmdata,i);
split(rowcon,rdp,"\t");
for(j=0;j<4;j++)
{
printf("R"&i+1&", C"&j+1&": "&rdp[j+1]);
ddt_set_val_by_row(dqmdata,i+1,"C"&(j+1),rdp[j+1]);

}
}

db_disconnect(Session);
ddt_save(dqmdata);
ddt_close(dqmdata);


answer by: Naga Chiranjeevi Kota(iGATE)

What all are the different databases winrunner can support?

1978

---

What is the purpose of set_window command?

1325

---

What is debug mode in Winrunner?

2299

---

What is the difference between writing a function and writing a script?

1395

---

What Framework is suitable to validate the Login screen.

2573

---

Explain difference between winrunner and test director?

1224

---

What is test parameter

2302

---

What are the virtual objects and how do you learn them?

1305

---

How do you execute your tests from windows run command?

2069

---

How do you handle tsl exceptions?

1248

---

How enviornment veriable can be included into my script. I want to include some information into my Excel file using Test run in WR. like User name of system? waht is function to be used? Please clarify.....

2270

---

What is the use of gui map and what happens when the gui map file get loaded?

1192

---

For my web Application I am recording website by WR. but the fuctions are displaying normal recorded fun. such as set_window...etc. eventhough i selected web add-in at start up WR. how to use web functions? such as web_link_click.... pls. guide

2313

---

What are data driven tests?

1227

---

Why don’t we normally load the gui maps through start up scripts?

1141

---