while getting the data from the LMN column just compare if its a empty string if its empty then skip the row go to next row.
On Wed, Aug 11, 2010 at 2:42 PM, venkat ch12 <[email protected]> wrote: > 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]<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
