Contents
| | |
|
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 bemyRS.UpdateBatchorADC1.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
See Also
Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.