Syntax

Visual Basic (Declaration)
Public Function MVResultSetGetRow() As Integer

C#
public int MVResultSetGetRow()

C++
public: int MVResultSetGetRow() sealed

J#
public int MVResultSetGetRow()

JScript
public function MVResultSetGetRow() : int

Return Value

An integer containing the current row number

Remarks

Example connects and executes a query to retrieve contactname and city from the CUSTOMERS file and displaying a message on the fifth row

	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 If mvsp.MVResultSetGetRow = 5 then Msgbox("Got to the 5th row") End if txt = mvsp.MVResultSetGetCurrentRow ListBox1.Items.Add(mvspf.Extract(txt, 1)) End While End if End if returncode = mvsp.CloseConnection()

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
          If mvsp.MVResultSetGetRow = 5 then
             Msgbox("Got to the 5th row")
          End if
          txt = mvsp.MVResultSetGetCurrentRow
          ListBox1.Items.Add(mvspf.Extract(txt, 1))
       End While
    End if
 End if
 returncode = mvsp.CloseConnection()

Syntax

Return Value

Remarks

See Also