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
- 4307 Views
- I also Faced
- E-Mail Answers
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 |
What is the difference between a Defect & an Error?
What is the purpose of regexp_label property and regexp_msw_class property?
How do you invoke a text file from winrunner?
what is the TSL statement for pass/fail crieteria appear in the test results of TD?
What is tsl? What 4gl is it similar too?
How would you define a "bug?"
what is custom check point? what is the diff.between custom check point and runtime Record check ?
2 Answers Infeneon Technologies,
This Is Sekar, Can Any One Of You Help Me? Question: How To Draw Charts In Excel Sheet Using Winrunner Scripts. Thanks, Sekar.
hi, this is balu. I looking for testing job. I want qtp software . any body have . pls send mail to me dont forget. send a mail to me kool.balu@gmai.com
what is the advantage of INOUT parameter over OUT parameter?
how u can do parameterization in winrunner? tell me the sample code.
what is the difference between synchronization pt and wait statement. what are the advanatages and disadv..of context sensitive and analog recording
WinRunner 
