Rows (Rowsets)
Rows are an important object that enables OLE DB components to export (Expose) and operational data in tabular form. Row set objects are a collection of rows, and each row is composed of data columns.
CoType TRowset {[mandatory] interface IAccessor; [mandatory] interface IColumnsInfo; [mandatory] interface IConvertType; [mandatory] interface IRowset; [mandatory] interface IRowsetInfo; [optional] interface IChapteredRowset; [optional] interface IColumnsInfo2; [optional] interface IColumnsRowset ; [optional] interface IConnectionPointContainer; [optional] interface IDBAsynchStatus; [optional] interface IGetRow; [optional] interface IRowsetChange; [optional] interface IRowsetChapterMember; [optional] interface IRowsetCurrentIndex; [optional] interface IRowsetFind; [optional] interface IRowsetIdentity; [ optional] interface IRowsetIndex; [optional] interface IRowsetLocate; [optional] interface IRowsetRefresh; [optional] interface IRowsetScroll; [optional] interface IRowsetUpdate; [optional] interface IRowsetView; [optional] interface ISupportErrorInfo; [optional] interface I RowsetBookmark;}
Creating a rowset consumers can use one of the following methods to get a rowset object:
Call the IOPENROWSET :: OpenRowset in the current meeting object to create a rowset object. All providers must support the IOPENROWSET interface. Call IDBCREATECOMMAND :: CreateCommand to get the command object in the meeting object. Then call iCommand :: Execute in the command object. If there is only one command, return the result line. For example, a SQL SELECT statement, iCommand :: execute returns a rowset, or consumers request that iMultlesults will return multiple result objects. Consumers call the method returns the row set plan or set of rows (schema rowset) for example IColumnsRowset :: GetColumnsRowset, IDBSchemaRowset :: GetRowset, IViewRowset :: OpenViewRowset, or ISourcesRowset :: GetSourcesRowset. Consumers call other method returns the row set similar table format Results (Returns Tablular Results as a rowset).
