CreateRecordset Method

Creates an empty, disconnected ADODB.Recordset.

Syntax

object.CreateRecordset(ColumnInfos)

Part	Description

object	An object variable that represents an RDSServer.DataFactory or RDS.DataControl object.
ColumnsInfos	A Variant array of arrays defining each column in the Recordset being created. Each column definition contains an array of four required attributes: Name ù Name of the column header. Type ù Integer of data type. Size ù Integer of width in characters, regardless of data type. Nullability ù Boolean value. The set of column arrays is then grouped into an array, which defines the Recordset.

Applies To

RDSServer.DataFactory, RDS.DataControl

Remarks

The server-side business object can populate the resulting ADODB.Recordset with data from a non-OLE DB data provider, such as an operating system file containing stock quotes.

To sort on a Recordset, any pending changes must first be saved. If you are using the RDS.DataControl, you can use the SubmitChanges method. For example, if your RDS.DataControl is named ADC1, your code would be ADC1.SubmitChanges. If you are using an ADO Recordset, you can use its UpdateBatch method. Using UpdateBatch is the recommended method for Recordset objects created with the CreateRecordset method. For example, your code could be myRS.UpdateBatch or ADC1.Recordset.UpdateBatch.

The following table lists the data types supported by the RDSServer.DataFactory object's CreateRecordset method. The number listed is the reference number used to define fields.

Each of the data types is either fixed length or variable length. Fixed length types should be defined with a size of û1, because the size is predetermined and a size definition is still required. Variable length data types allow a size from 1 to 32767.

For some of the variable data types, the type may be coerced to the type noted in the Substitution column. You won't see the substitutions until after the Recordset is created and filled. Then you can check for the actual data type, if necessary.

Length	Constant	Number	Substitution

Fixed	adTinyInt	16
Fixed	adSmallInt	2
Fixed	adInteger	3
Fixed	adBigInt	20
Fixed	adUnsignedTinyInt	17
Fixed	adUnsignedSmallInt	18
Fixed	adUnsignedInt	19
Fixed	adUnsignedBigInt	21
Fixed	adSingle	4
Fixed	adDouble	5
Fixed	adCurrency	6
Fixed	adDecimal	14
Fixed	adNumeric	131
Fixed	adBoolean	11
Fixed	adError	10
Fixed	adGuid	72
Fixed	adDate	7
Fixed	adDBDate	133
Fixed	adDBTime	134
Fixed	adDBTimestamp	135	7
Variable	adBSTR	8	130
Variable	adChar	129	200
Variable	adVarChar	200
Variable	adLongVarChar	201	200
Variable	adWChar	130
Variable	adVarWChar	202	130
Variable	adLongVarWChar	203	130
Variable	adBinary	128
Variable	adVarBinary	204
Variable	adLongVarBinary	205	204

Example

See Also

Defining a Recordset