Forum Discussion

rramkis's avatar
rramkis
New Contributor
9 years ago

need to retrieve a row number where expected values find

I have a one table. in the table I want to retrieve a some expected values let assume that A,B,C these three I want to find . once its found I want to retrieve row number of each one.. the row number...
NisHera's avatar
NisHera
Valued Contributor
9 years ago

This is kinda psudo code for your problem 

Looks more like jscript

have to rewite in vbs and get values using correct grid methods

For (i =0 to RowCount){
    var AExist = false
    var BExist = false
    var CExist = false
    For (j = 0 to columncount){
	     P = grid.wvalue(i,j)
	     if (p == A)
		   {AExist = true}
	     if (P == B)
		   {BExist = true}
             if (P == C)			
		   {CExist = true }}
    If (AExist and BExist and CExist)	 
	  {Log. message ("A B C Exists in the row number "+ i) }}