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)

Whats a difference between Verification Point and Syncronization point?

6 Answers   AZTEC, CTS,

---

what is the purpose of '*', '&','.' symbols in Regular Expressions (winrunner)?

1 Answers  

---

How can integration testing be done through winrunner??

1 Answers   Satyam,

---

what are Obligatory and Optional properties in Winrunner? what is the use of those explain in detail..

2 Answers   Kanbay,

---

what is contained in the GUI check list?

1 Answers   FCG,

---

How to set a value in to a data table from the script in winrunner?

1 Answers   Accenture,

---

If I do not check any of the add-ins that pops up initially, for which type of application can I do scripting?

2 Answers   Sonata,

---

when obligatory & optional properties cannot uniquely identifying an object then in that case which method u r follow for identifying object in Win Runner ?

1 Answers   MBT,

---

How to Import(insert) data from an excel sheet to Database(table).

2 Answers   GE Capital, iGate,

---

which function you will use to compare the application date with system date?..

1 Answers   ASD Lab, TCS,

---

Where are test cycle folders created if TSL Script is not saved

1 Answers  

---

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

0 Answers   ABC, Excelacom,

---