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
- 4393 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
What is toogle breakpoints? How does it differ from break points?
Name the different modes of recording?
When it is appropriate to change physical description?
what is the difference between toggle checkpoint and checkpoint?
What are the reasons that winrunner fails to identify gui object?
I want to do smoke test in my application but i have learnt the application before recording but im getting an error class name not found while running the script.I want to check each links and each text in my application. Can anybody answer my quesion plz.If it is possible i want test script for Yahoo login form with "New User" Login.
i would like to know the steps to write tsl exception and object exception with a simple example
How do you make the configuration and mappings permanent?
Name the three modes of running the scripts?
Explain the difference between gui map and gui map files?
What is the use of gui map and what happens when gui map file get loaded?
Which are default codes winrunner generates when we start the application?
How do u check FONTS in Login Window?
How do you find out which is the start up file in winrunner?
Without the gui map, use the phy desc directly?
