Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 4319 Views
- I also Faced
- E-Mail Answers
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
How to find the local host name using winrunner ?
What do you verify with the sync point for object/window bitmap and what command it generates, explain syntax?
What is the purpose of regexp_label property and regexp_msw_class property?
What is parameterizing?
When do you feel you need to modify the logical name?
what is the difference between toggle checkpoint and checkpoint?
How to do text matching?
How do you find an object in an gui map.
can i get apex technologies interview questions in testing
What are the different modes of recording in winrunner?
What is the purpose of gui map configuration?
plz give me code or steps for pop up exception. or can u tell me how to pause test run for defining handler function?
What are the two modes of recording?
wat is the d/b windows 95&98&xp?could anybody give reply ?
What are the platforms that WinRunner can be used?
