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
- 4322 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 |
how u can crate a database checkpoint in ur script?
Welcome link is dynamic. How do you handle? What is your approach and write script.plz send answer
can anybody tell me what is project architecture?
How to force wr to learn the sub-items on a menu?
What are all the parameters used in Winrunner? What is actual parameter and formal parameter?
In an Interview on person asked me about WR frame work. in what way i have to explain and what is the answer?
what is automation life cycle?
what is the difference between data driven test(ddt) and parametrization
7 Answers Agile Software, CTS,
if a test script is parameterised with the same value ,and run what effect will it have in terms of performance for testing the application.will the script get executed faster or there is no effect at all.
Are you created any custom dialog box during test runs?
What is parameterizing?
which checkpoint is used to analyze the appearance of AUT
WinRunner 
