1 Reply Latest reply on Sep 12, 2008 6:16 PM by dbmaven

    MoveNext() and MovePrev()  functions

    649697
      When I am pointing to a table row if I MoveNext(), get data and then return back with MovePrev() the row is not the old pointed row. What I can do to be sure to return back to the same position ?
      tank you
        • 1. Re: MoveNext() and MovePrev()  functions
          dbmaven
          You could use the bookmark feature.

          OraDynaset = is the data returned to your application from Oracle

          Set the bookmark:
          strBookmark = OraDynaset.Bookmark

          Do your processing or whatever you need to

          Then go back to your bookmark

          OraDynaset.Bookmark = strBookmark

          You can also search in the dynaset:
          strFindClause = "Key = " & OraDynaset("KEY")
          OraDynaset.FindFirst strFindClause

          If OraEPAEMP.NoMatch Then
          'means you did not find the bookmark again
          else
          ' it found the bookmark and you can continue from here
          endif