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
- 4226 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 Add Watch?
Wat is the defferances between Test plan and devolopment plan?
what happens when the script is executed in verify mode
What are Optinal Properties and Obligation Properties? please explain in detail.
How many check points are there in winrunner? what are they?
what is contained in the GUI check list?
how can you explain your Real Estate Project in front of interviewer..? please step by step......
Hiiiiiiiii This is lavanya.....At present i m working as a MATLAB developer at CMC(A tata enterprise)from about1 year .now i want to move to testing field as a fresher?Is this possible...can anyone give me a suggestion regarding d testing field.....
what is batch mode, how can u run ur tests in batch mode?
How many exceptions are there in winrunner and what are they?
how u can do parameterization in winrunner? tell me the sample code.
What is the TSL function in WinRunner to connect to test director?
1 Answers Infosys, Kanbay, Scope International,
WinRunner 
