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 / 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 do you find an object in an gui map.
What are all the parameters used in Winrunner? What is actual parameter and formal parameter?
How to get the resolution settings?
How to get the system date and time in winrunner?
global sheet and external excel sheet how it will work
How winrunner recognise window/object apart from GUI map file?
How to close the winrunner window from the script itself?what is the code?
How many types of tests can u create in winrunner?
please tell me how to explain the project by taking any project (like banking product), how to start explaing?what will be the order of priority e.g.,like purpose, modules, HLDs LLDs etc., in testing point of view (as a testengineer). rightnow i can't explain my project though i've done successfully..so plz help me ..
9 Answers HCL, IBM, ITC Infotech, Raisoni, TCS, Wipro,
How should we create a compiled module? What is its importance?
What are the advantages and disadvantages of Context sensitive and Analog Recording?
How can I check the font size and color using winrunner?