📚 SAP Business One SDK Help

Recordset Object Members
See Also  Overview 

Public Methods

Public Method DoQueryRuns SQL queries.
Public Method GetAsXMLReturns the object from XML data, which is stored as string in a buffer.
Public Method GetFixedSchemaThe schema for the XML returned by the GetFixedXML method.
Public Method GetFixedXMLReturns 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.

Public Method MoveFirstMoves the curser to the first row in the result set.
Public Method MoveLastMoves the curser to the last row in the result set.
Public Method MoveNextMoves the curser to the next row in the result set.
Public Method MovePreviousMoves the curser to the previous row in the result set.
Public Method SaveToFileSave the object to a file as XML data.
Public Method SaveXMLSaves the query data to an XML file or a string.

For more information, see Exchanging Data Using the DI API XML Capabilities.

Public Properties

Public Property BoFReturns a Boolean value that indicates whether or not the current row is the first row in the result set (Beginning of File).
Public Property CommandReturns the Command object that enables to execute SQL stored procedures.
Public Property EoFReturns a Boolean value that indicates whether or not the current row is the last row in the result set (End of File).
Public Property FieldsReturns a Fields collection, which contains the fields of the result set.
Public Property RecordCountReturns the number of records contained in the result set.
Public Property RecordSetAuditFor 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.

See Also