Syntax

Visual Basic (Declaration)
Public Function MVResultSetGetColumn() As String

C#
public string MVResultSetGetColumn()

C++
public: String MVResultSetGetColumn() sealed

J#
public string MVResultSetGetColumn()

JScript
public function MVResultSetGetColumn() : String

Return Value

A space seperasted string containing the column names in the current result set

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", "") txt = mvsp.MVResultSetGetColumn() ' Returns a space seperated string containing the column names CONTACTNAME and CITY 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", "")
       txt = mvsp.MVResultSetGetColumn() ' Returns a space seperated string containing the column names CONTACTNAME and CITY
    End if
 End if
 returncode = mvsp.CloseConnection()

Syntax

Return Value

Remarks

See Also