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 Posted / 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 |
Post New Answer View All Answers
Have you used winrunner in your project?
How do you handle unexpected events and errors?
Have you ever created a start-up script?
How to to get the information from the status bar without doing any activity/click on the hyperlink?
supose 10 times text data is there but it will run 8 times whtat will you do.
plz give me code or steps for pop up exception. or can u tell me how to pause test run for defining handler function?
How to force wr to learn the sub-items on a menu?
descriptive program for web application.
What do you mean by the logical name of the object.
Explain difference between winrunner and test director?
Name the two modes of recording?
How do you identify which files are loaded in the gui map?
Without the gui map, use the phy desc directly?
What is the extension of gui map file?
What is tsl? What 4gl is it similar too?