This method moves the current row pointer onto the next row in the result set


Namespace: rocketsoftware.MVSP
Assembly: RocketMVSP (in RocketMVSP.dll)

Syntax

Visual Basic (Declaration)
Public Function MVResultSetNext() As Boolean
C#
public bool MVResultSetNext()
C++
public:
 bool MVResultSetNext() sealed 
J#
public bool MVResultSetNext()
JScript
public  function MVResultSetNext() : bool

Return Value

True if the pointer was incremented or False if already at the last row

Remarks



Example connects and executes a query to retrieve contactname and city from the CUSTOMERS file.

 Copy Code
 Dim returncode as boolean
 Dim mvsp as new rocketsoftware.MVSP.Pick
 Dim txt as string 
 returncode = mvsp.Connect("localhost",9000,"dm","")
 If returncode = True then
    returncode = mvsp.Logto("MVDEMO","")
    If returncode = True then
       mvsp.ExecuteQuery("QUERY", "CUSTOMERS", "", "", "CONTACTNAME CITY", "")
       While mvsp.MVResultSetNext = True ' While True a row is available
          txt = mvsp.MVResultSetGetCurrentRow
          ListBox1.Items.Add(mvspf.Extract(txt, 1))
          ListBox2.Items.Add(mvspf.Extract(txt, 2))
       End While
    End if
 End if
 returncode = mvsp.CloseConnection()
 

See Also