This method allows you to execute an AQL query on the multivalue server and get a structured array returned containing the results.


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

Syntax

Visual Basic (Declaration)
Public Sub ExecuteQuery( _ 
   ByVal queryCmd As String,  _ 
   ByVal queryFilepath As String,  _ 
   ByVal queryWith As String,  _ 
   ByVal querySortby As String,  _ 
   ByVal queryADIList As String,  _ 
   ByVal queryItemids As String _ 
)
C#
public void ExecuteQuery(
   string queryCmd,
   string queryFilepath,
   string queryWith,
   string querySortby,
   string queryADIList,
   string queryItemids
)
C++
public:
 void ExecuteQuery(
   String queryCmd,
   String queryFilepath,
   String queryWith,
   String querySortby,
   String queryADIList,
   String queryItemids
) sealed 
J#
public void ExecuteQuery(
   string queryCmd,
   string queryFilepath,
   string queryWith,
   string querySortby,
   string queryADIList,
   string queryItemids
)
JScript
public  function ExecuteQuery(
   queryCmd : String,
   queryFilepath : String,
   queryWith : String,
   querySortby : String,
   queryADIList : String,
   queryItemids : String
)

Parameters

queryCmd
This is the command that you wish to execute. Valid values are QUERY, LIST or SORT
queryFilepath
This is the full path to the file that you wish to query
queryWith
Optional with clause
querySortby
Optional by clause
queryADIList
List of the dictionary items that you wish to retrieve data for
queryItemids
Optional list is item ids

Remarks



Example connects and executes a query to retrieve contactname and city for all contactnames starting with Robert and sorted by city from the CUSTOMERS file.

 Copy Code 
 Dim returncode as boolean
 Dim mvsp as new rocketsoftware.MVSP.Pick
 Dim mvspf as new rocketsoftware.MVSP.Functions
 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", "WITH CONTACTNAME = ""ROBERT]""", "BY CITY", "CONTACTNAME CITY", "")
       While mvsp.MVResultSetNext = True
          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

Syntax based on .NET Framework version 2.0.
Documentation version 2.1.0.0.