Sets or returns a value that indicates the operational type or data type of an object.
Syntax
VOIDSetType(SHORT sType );
SHORTGetType(VOID);
Remarks
For a CdbField or CdbProperty object, this property is read/write until the object is appended to a collection or to another object, after which it's read-only. For a CdbParameter object in a Microsoft Jet workspace the property is read-only, while in an ODBCDirect workspace the property is always read-write. For any of these objects, the possible settings and return values are described in the following table.
Constant | Description |
dbBigInt | Big Integer |
dbBinary | Binary |
dbBoolean | Boolean |
dbByte | Byte |
dbChar | Char |
dbCurrency | Currency |
dbDate | Date/Time |
dbDecimal | Decimal |
dbDouble | Double |
dbFloat | Float |
dbGUID | GUID |
dbInteger | Integer |
dbLong | Long |
dbLongBinary | Long Binary (OLE Object) |
dbMemo | Memo |
dbNumeric | Numeric |
dbSingle | Single |
dbText | Text |
dbTime | Time |
dbTimeStamp | Time Stamp |
dbVarBinary | VarBinary |
For a CdbQueryDef object, the property is read-only. The possible return values are shown in the following table.
Constant | CdbQueryDef type |
dbQAction | Action |
dbQAppend | Append |
dbQCompound | Compound |
dbQCrosstab | Crosstab |
dbQDDL | Data-definition |
dbQDelete | Delete |
dbQMakeTable | Make-table |
dbQProcedure | Procedure (ODBCDirect workspaces only) |
dbQSelect | Select |
dbQSetOperation | Union |
dbQSPTBulk | Used with dbQSQLPassThrough to specify a query that doesn't return records (Microsoft Jet workspaces only). |
dbQSQLPassThrough | Pass-through (Microsoft Jet workspaces only) |
dbQUpdate | Update |
Note To create an SQL pass-through query in a Microsoft Jet workspace, you don't need to explicitly set the Type property to dbQSQLPassThrough. The Microsoft Jet database engine automatically sets this when you create a CdbQueryDef object and set the Connect property.
For a CdbRecordset,object, the property is read-only, and the possible return values are as follows.
Constant | CdbRecordset type |
dbOpenTable | Table (Microsoft Jet workspaces only) |
dbOpenDynamic | Dynamic (ODBCDirect workspaces only) |
dbOpenDynaset | Dynaset |
dbOpenSnapshot | Snapshot |
dbOpenForwardOnly | Forward-only |
For a CdbWorkspace object, the property is read-only, and the possible settings are as follows.
Constant | CdbWorkspace type |
dbUseJet | The CdbWorkspace is connected to the Microsoft Jet database engine. |
dbUseODBC | The CdbWorkspace is connected to an ODBC data source. |
When you append a new CdbField, CdbParameter, or CdbProperty object to the collection of an CdbIndex, CdbQueryDef, CdbRecordset, or CdbTableDef object, an error occurs if the underlying database doesn't support the data type specified for the new object.