How to Get data from database(table) to an excel sheet
Answer Posted / naga chiranjeevi kota
Session="mysession";
connstring="DSN=DQMCHIRU;UID=dqm5map;pwd=dqm5map;server=Orcl";
rc=db_connect(Session,connstring);
x="select PART_NUM,PART_ORG ,RDX_ID,DESCRIPTION from
reference_data_part where part_num like '%31' order by
PART_NUM";
printf(x);
# Opening the excel sheet
dqmdata = "C:\ExecuteSampleData.xls";
rc = ddt_open(dqmdata, DDT_MODE_READWRITE);
if (rc!= E_OK && rc != E_FILE_OPEN)
pause("Cannot open table.");
dc=db_execute_query(Session,x,rows);
#ddt_get_row_count(dqmdata,rows);
for(i=0;i<rows;i++)
{
db_get_row(Session,i,rowcon);
#ddt_set_row(dqmdata,i);
split(rowcon,rdp,"\t");
for(j=0;j<4;j++)
{
printf("R"&i+1&", C"&j+1&": "&rdp[j+1]);
ddt_set_val_by_row(dqmdata,i+1,"C"&(j+1),rdp[j+1]);
}
}
db_disconnect(Session);
ddt_save(dqmdata);
ddt_close(dqmdata);
answer by: Naga Chiranjeevi Kota(iGATE)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you handle unexpected events and errors?
How to do text matching?
How to break infinite loop?
Which are default codes winrunner generates when we start the application?
by useing qtp where the maximum people feeling difficult
How do you execute your tests from windows run command?
When it is appropriate to change physical description?
Without the gui map, use the phy desc directly?
Dear all i am new to testing my company using vb.net and we are developing web based application. How i can test those application with winrunner if any one have some good tutorial or link kindly provide thanks u.
Explain the purpose of loading winrunner add-ins?
How do you handle pop-up exceptions?
How to force wr to learn the sub-items on a menu?
How can withwin runner to make single scripts which supports multiple languages?
what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance
What different actions are performed by find and show button?