Answer / atif

csv =comma separater version

Answer / 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 Add Watch?

6 Answers   Accenture,

---

What is the Difference between the versions of WinRunner7.1 and WinRunner7.6? What r the advantages of WR7.6 than WR 7.1 and Which type of Browsers they support?

1 Answers   Scandent,

---

what is the use of _set_window in winrunner?

11 Answers   Wipro,

---

When Bitmap check point fails..How many windows will appear?

3 Answers   Symphony,

---

global sheet and external excel sheet how it will work

0 Answers  

---

How do handle error/exceptions in winrunner.

2 Answers   ADITI,

---

how many license keys are there for winrunner in your company?

3 Answers   MBT,

---

How to carry out manual testing for a background process which does't have any user interface

1 Answers  

---

how to upload an application in winrunner which we want to test

1 Answers  

---

What is the use of test director testing tool?

0 Answers  

---

how do you rate your self in winrunner

2 Answers   Infosys,

---

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

0 Answers  

---