🚀 go-pugleaf

I didn't try it but I would do :
   R1 = Form.DATAMODREF1.ref.basename1.rowset
   R1.first()
   DO WHILE NOT R1.endOfSet  // no parenthesis
      IF R1.fields["MYFIELD"].value=something
         DO something  // ex : R1.fields["MYFIELD"].value=somethingelse
      ENDIF
      R1.next()
   ENDDO

But if your table is very big AND already indexed on MyField, I would rather
do :
   R1 = Form.DATAMODREF1.ref.basename1.rowset
   R1.setRange("MYFIELD = 'something' ")
   IF R.count() > 0
      R1.first()
      DO WHILE not R1.endOfSet  // no parenthesis
         DO something  // ex : R1.fields["MYFIELD"].value=somethingelse
         R1.next()
      ENDDO
   ELSE
      MsgBox("No record contains " + trim(something)), " Sorry . . . ", 48)
   ENDIF
   R1.clearRange()


Jean-Pierre Martel
MGA Communications - Montr�al - Canada

Enes Boric a �crit dans le message <36892BFF.62703CDB@ionline.net>...
>I'm trying to make something like this into vdb 7.1 but
>I can't.
>
>I tried
>r=form.DATAMODREF1.ref.basename1.rowset
>r.first()
>DO WHILE NOT rowset.endOfSet()
>   IF r.fields["MYFIELD"].value=something
>      DO something  (r.fields["MYFIELD"].value=something etc)
>   ENDIF
>   r.next()
>ENDDO
>
>But I couldn't get the resoults that I expected. Can somebody please
>tell me where
>i'm making the mistakes?
>Thank you.