Answer Posted / naga chiranjeevi kota

Session="mysession";

connstring="DSN=DQMCHIRU;UID=scott;pwd=tiger;server=Orcl";
rc=db_connect(Session,connstring);
dqmdata = "C:\TestSheet.xls";
rc = ddt_open(dqmdata, DDT_MODE_READWRITE);

ddt_get_row_count(dqmdata,noOfRows);
printf(noOfRows);
for(i=0;i<noOfRows;i++)
#for(i=0;i<1;i++)
{
a = ddt_val_by_row(dqmdata,i+1,"a");
b = ddt_val_by_row(dqmdata,i+1,"b");
c = ddt_val_by_row(dqmdata,i+1,"c");
d = ddt_val_by_row(dqmdata,i+1,"d");
x="insert into dqmchiru values('"&a &"','"&b &"','"&c
&"','"&d&"')";
printf("R"&i+1&": "&x);
dc=db_execute_query(Session,x,rows);

}
dc=db_execute_query(Session,"Commit",rows);
db_disconnect(Session);
ddt_save(dqmdata);
ddt_close(dqmdata);


answer by: Naga Chiranjeevi Kota(iGATE)

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

2059

---

What are the Win Runner tools for functional testing?

3011

---

Have you ever created a start-up script?

1178

---

What is the purpose of a gui spy?

1180

---

What Framework is suitable to validate the Login screen.

2506

---

What is the purpose of gui map configuration?

1117

---

i would like to know the steps to write tsl exception and object exception with a simple example

2224

---

What are data driven tests?

1158

---

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

1214

---

What is the purpose of regexp_label property and regexp_msw_class property?

1200

---

Have you used winrunner in your project?

1063

---

What is the purpose of gui spy?

1278

---

How do you handle unexpected events and errors?

1122

---

How do you select multiple objects during merging the files?

1191

---

soft key for virtual object wizard ?

2392

---