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
