Type Property

    Example    Applies To

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.