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
- 4300 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 many recording modes are provided by WR?
How to write a content in to the file..which function did u use for that..?
What is boundary test?
can we run compiled-mod function in a compiled module function?if yes then fwd sample script?
what happens when the script is executed in verify mode
Explain the winrunner testing process?
What is Syncronisation in Winrunner?
How to have winrunner insert yesterdays date into a field in the application?
Can we use the user defined functions (which inclues script with GUI functions) in Compile module? Example: public function MyGuiFun() { set_window(?Browser main window?); button_press(?OK?); } If yes. pls give some example, how to handle...!
How do u check FONTS in Login Window?
My husband had stampped h1b visa and was valid for another 1year. problm is that he lost his pasport in travelling and we got new one in tatkal scheme. and so we applied for restamping and my dependent (h4)visa. As per immigration team petition will be the same only stamping has to b done.. what questions will they ask and what are the chances to get it aproved?? pl reply
wahat do u mean by exceptional handling in winrunner
WinRunner 
