In my application I was supposed to test two columns.The
first column1 belongs to one module and the other column2
belongs to other module.The content in both the columns is
same.I supposed to check whether the data present in the
column1 is same as the one in column2.
Each column contains number of rows.So checking each row
manually is diificult.Is there any option available in
WinRunner or QTP to check the column data.These two columns
are available in Data Base Tables.
One way is that I can just number of rows in each column so
that I can get rows count of both the columns,but apart
from that I was supposed to check whether the data is also
same in both the tables.
Can anybody suggest me how I can go about this.
Answer / poonam
Following is the solution for your query.
# Fetching Information from Database
j = db_connect
("query1","DSN=<name>;UID=<user_id>;PWD=<user_pwd>",30);
if (j == E_OK) {
db_execute_query("query1", "select * from
<table name>", record_no);
for(i = 1;i <= record_no; i++) {
k = i-1;
val = db_get_field_value
("query1", "#"&k, "#0");
val1 = db_get_field_value
("query1", "#"&k, "#1");
if (val == val1)
report_msg("Values are
same "&val "and " &val1);
else
report_msg("Values are not
same");
}
}
else
report_msg("Database Connection Failed");
db_disconnect("query1");
| Is This Answer Correct ? | 1 Yes | 0 No |
If winrunner doesn't understand the Text in the Application what you do?
hi,i am sudha.i am married.i had done my BE in 2005.i learnt testing tools.i dont no how to tell about my self.please send me good answer about that infomation i gave.
what type of licence key r u using for winrunner software in your company?
How to calculate the edit field length
In my application I was supposed to test two columns.The first column1 belongs to one module and the other column2 belongs to other module.The content in both the columns is same.I supposed to check whether the data present in the column1 is same as the one in column2. Each column contains number of rows.So checking each row manually is diificult.Is there any option available in WinRunner or QTP to check the column data.These two columns are available in Data Base Tables. One way is that I can just number of rows in each column so that I can get rows count of both the columns,but apart from that I was supposed to check whether the data is also same in both the tables. Can anybody suggest me how I can go about this.
Whole application is taking as single html frame while recording and learning but i want to learn each textbox,text,links whatever the page have.If we click any link in one page that will show another page so i want to learn that pages objects also.I want navigation steps or guidence plz
In general, how do you see automation fitting into the overall process of testing?
Explain the purpose of gui map configuration?
What is the use of the "Find" Button in Gui Map Editor?
what are the stages of software development life cycle?
5 Answers Agility e-Services, Trigent,
what is the purpose of verify,update and debug modes in wr?
how are objects identified by winrunner