DoQuery | Runs SQL queries. |
 GetAsXML | Returns the object from XML data, which is stored as string in a buffer. |
 GetFixedSchema | The schema for the XML returned by the GetFixedXML method. |
 GetFixedXML | Returns the query data as XML based on a fixed schema.
The GetAsXML also returns the data as XML, but the schema is dynamic and based on the specific query. With the GetFixedXML, the schema is fixed and is available with the GetFixedSchema method. You can use the schema, for example, to create a .NET object for handling the query XML. For more information, see Exchanging Data Using the DI API XML Capabilities. |
 MoveFirst | Moves the curser to the first row in the result set. |
 MoveLast | Moves the curser to the last row in the result set. |
 MoveNext | Moves the curser to the next row in the result set. |
 MovePrevious | Moves the curser to the previous row in the result set. |
 SaveToFile | Save the object to a file as XML data. |
 SaveXML | Saves the query data to an XML file or a string.
For more information, see Exchanging Data Using the DI API XML Capabilities. |
 BoF | Returns a Boolean value that indicates whether or not the current row is the first row in the result set (Beginning of File). |
 Command | Returns the Command object that enables to execute SQL stored procedures. |
 EoF | Returns a Boolean value that indicates whether or not the current row is the last row in the result set (End of File). |
 Fields | Returns a Fields collection, which contains the fields of the result set. |
 RecordCount | Returns the number of records contained in the result set. |
 RecordSetAudit | For security enhancement, if this flag is set to true, the querying will be logged in table RSAT. By default, the flag is set to false. |
Â
Â