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)

How to have winrunner insert yesterdays date into a field in the application?

1119

---

What is the XML test cases creation?

2742

---

What is the usage of Test case Design Techniques,in Integration/System Testing?

2548

---

wat is the d/b windows 95&98&xp?could anybody give reply ?

2380

---

The title of the window consists of date and time.What is the regular expression to recognize the window as unique?

2118

---

How to to get the information from the status bar without doing any activity/click on the hyperlink?

1133

---

What is the purpose of the temp GUI map file?

1263

---

When do you feel you need to modify the logical name?

1133

---

How do you call windows APIs, explain with an example?

2110

---

what is the use of generate script that is avaliable 3 places(file settings, tools, object identification)

2558

---

How to find the local host name using winrunner ?

2305

---

Define parameterizing?

1131

---

What is tsl? What 4gl is it similar too?

1300

---

What is the purpose of gui spy?

1329

---

How do you find out which is the start up file in winrunner?

1188

---