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)

what is the difference between toggle checkpoint and checkpoint?

5245

---

How to force wr to learn the sub-items on a menu?

1086

---

What Framework is suitable to validate the Login screen.

2572

---

Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....

2433

---

What is the purpose of regexp_msw_class property?

1182

---

What is the purpose of regexp_label property and regexp_msw_class property?

1268

---

This Is Sekar, Can Any One Of You Help Me? Question: How To Draw Charts In Excel Sheet Using Winrunner Scripts. Thanks, Sekar.

2227

---

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

1392

---

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

1314

---

How do you select multiple objects during merging the files?

1245

---

Without the gui map, use the phy desc directly?

1106

---

How to do text matching?

1169

---

How do you make the configuration and mappings permanent?

1130

---

What is the XML test cases creation?

2747

---

What is the difference between gui map and gui map files?

1218

---