Creates an empty, disconnected ADODB.Recordset of a specified shape, which must be defined.
Syntax
object.CreateRecordset(ColumnInfos)
| Part | Description |
| object | An object variable that represents an RDSServer.DataFactory 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:
The set of column arrays is then grouped into an array, which defines the Recordset. |
Applies To
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.
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 |
See Also