HI Venkat, create a ADODB connection for the database. In SQL query parametrize the where part with the data you capture form the table.
Now start a loop with no of rows in the table. For each row check the LMN data and then put that data in the SQL query and retrieve a row of data. In that row of data find out the price unit data based on the field name and compare with the table value. I hope its clear. if not please let me know. Thanks Biswajit On Mon, Aug 9, 2010 at 8:46 PM, arihan sinha <[email protected]> wrote: > you need to pullout the value from the webtable particular cell no and > store it in variable say Var1 ... then through database connection pullout > the value through SQL query .. and store it in the Var2 and then compare if > Var1= Var2 or not like that.. > > > > On Mon, Aug 9, 2010 at 4:12 PM, venkat ch12 <[email protected]> wrote: > >> Hi All, >> >> I have a webtable(see attached) i need to check the webtable values with >> database values by connecting to database during execution >> >> Ex: i have a LMN column with the values i need to check the Units and >> price for that particular LMN , first these values i need to take from >> database and have to compare with the displayed values in the application >> during run time how can i do that comparision. The same comparision i need >> to do for all the columns >> >> Thanks >> Venkat >> >> -- >> 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]<mercuryqtp%[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]<mercuryqtp%[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
