Thnaks, One more thing how can i count the LMN displayed in the LMN column and how can i skip the empty rows in the row count
On Wed, Aug 11, 2010 at 12:01 PM, Biswajit Agarwal <[email protected]>wrote: > 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]<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
