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 to do text matching?

1135

---

Can anybody Explain me about the liasing with the developers,and a tester can make a test plan well?plz explain me as soon as possible ,thanx in advance.

2257

---

What is a checkpoint and what are different types of checkpoints?

1262

---

Difference between winrunner and test director?

1173

---

what is mean by release in quality center and who will perfom?

2983

---

how can you explain your Real Estate Project in front of interviewer..? please step by step......

1681

---

What is the purpose of gui spy?

1288

---

What is parameterizing?

1107

---

What is the purpose of gui map configuration?

1128

---

What is the use of virtual object wizard and how it is used?

1145

---

soft key for virtual object wizard ?

2410

---

what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance

1524

---

What are different types of checkpoints?

1187

---

What is the purpose of regexp_label property?

1112

---

What different actions are performed by find and show button?

1178

---