thanks , so cool.. From: [email protected] Date: Mon, 4 Apr 2011 18:28:30 +0530 Subject: Re: How to execute and compare database queries from excel sheet To: [email protected]; [email protected]
Hi All, I have enhanced the code but now it is giving me the different result in sheet number 2 i.e summary report sheet under the Unsuccessful rowcount section it is showing some large number when I use it as function library. However it is working fine when i use it in the script directly. Can anybody pls provides inputs on this. Thanks. Regards Shalabh Dixit On Thu, Mar 31, 2011 at 4:53 PM, Shibu Subhanandan <[email protected]> wrote: Nice...!! On Wed, Mar 30, 2011 at 10:03 PM, Shalabh Dixit <[email protected]> wrote: Hi Shibu, Yar actually, this is just to test the script, I have created the connection to same database.. I have checked both the scenarios of failure as well as success.... Regards Shalabh Dixit On Thu, Mar 31, 2011 at 9:33 AM, Shibu Subhanandan <[email protected]> wrote: Hi Shallabh, The scripts are goods. Thanks for sharing. But do you get message "Data Match Failure" from Report event at any of the scenario? Because i see single connection to a database Adventure Works and the queries in the excel in column 2 and 3 are executed on the same table. Please correct me if I am wrong? Thanks On Wed, Mar 30, 2011 at 11:53 AM, Shalabh Dixit <[email protected]> wrote: Hi All, Please find attached the script I prepared to solve my problem. Would appreciate your inputs on the same and other ways of doing the same in more efficient or better way. Regards Shalabh Dixit On Wed, Mar 30, 2011 at 3:55 PM, shashank shekhar raj <[email protected]> wrote: Tell me also how you did this. On Wed, Mar 30, 2011 at 12:32 AM, Shalabh Dixit <[email protected]> wrote: I'm done with it..!! On Mar 29, 8:33 pm, Shalabh Dixit <[email protected]> wrote: > Test case ID > Database1 Database2 > --------------------------------------------------------------------------- > --------------------------------------------- > 1 select count(*) TotalRecords > from select count(*) TotalRecords from > TableA where > abc='12' TableA where abc='12' > --------------------------------------------------------------------------- > --------------------------------------------- > 2 select count(*) TotalRecords > from select count(*) TotalRecords from > TableB where > abc='12' TableB where > abc='12' > --------------------------------------------------------------------------- > --------------------------------------------- > 3 select count(*) TotalRecords > from select count(*) TotalRecords from > TableC where > abc='12' TableC where > abc='12' > --------------------------------------------------------------------------- > --------------------------------------------- > Hi All, > > I have 1 excel template like above containing 3 columns namely > TestcaseID, Database1,Database2 as shown above. col2 and col3 contains > queries from tables for each database resp. > What I want is to execute each queries in the sheet corresponding to > each testcaseID and then compare the result of two queries... i.e > queries contains Count(*) function so I want to compare the value of > the two queries for each testcase ID. > Similarly there are many testcases for which i need to perform the > same operation. > > Can anybody pls provide their inputs on it. > > Thanks > Shalabh -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
