Syntax

Visual Basic (Declaration)
Public Sub MVResultSetClose()

C#
public void MVResultSetClose()

C++
public: void MVResultSetClose() sealed

J#
public void MVResultSetClose()

JScript
public function MVResultSetClose()

Remarks

Example connects and executes a query to retrieve contactname and city from the CUSTOMERS file stopping after 5 rows.

	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 mvsp.MVResultSetClose() Else txt = mvsp.MVResultSetGetCurrentRow ListBox1.Items.Add(mvspf.Extract(txt, 1)) ListBox2.Items.Add(mvspf.Extract(txt, 2)) End if 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
             mvsp.MVResultSetClose()
          Else
             txt = mvsp.MVResultSetGetCurrentRow
             ListBox1.Items.Add(mvspf.Extract(txt, 1))
             ListBox2.Items.Add(mvspf.Extract(txt, 2))
          End if
       End While
    End if
 End if
 returncode = mvsp.CloseConnection()

Syntax

Remarks

See Also