Page 1
Page 2
Page 3
Page 4
Page 5
The Help Files
Speaking of documentation, there are 2 very
important help files that come with SSCE, the one for SSCE and
the one for ADOCE. The SSCE file is named sqlce.chm and, if the
standard installation options were selected, is located in C:\Program
Files\Microsoft SQL Server CE\. It should also be installed
in the program group for SSCE. The ADOCE help file is adoce31.chm
and is located in C:\Windows CE Tools\dataaccess31\. The
SSCE documentation covers everything about SQL Server 2000 Windows
CE Edition, including support SQL, RDA, Replication, and OLEDB
Providers. The ADOCE help file covers ADOCE, SQL Statements, Error
Handling and ADOXCE, all of those as they pertain to ADO and CE.
Since the ADOCE documentation is geared towards ADO it contains
information such as that in listing 1. The last remark
in the listing 1 is "The above list includes all possible constants.
Check the provider documentation to see which constants are supported."
is straight from the ADOCE documentation. That leads to the SSCE
documentation, and when referenced it reveals specifics like those
in listing 2. Notice that ADOCE supports a lot more than
SSCE does! Less obvious is that SSCE only supports Unicode data
types. This fits with the fact that Windows CE is a Unicode only
operating system.
Listing 1 - ADOCE Data Types1
Type
This property specifies the data type of a Field object.
var = field.Type
Constants
The following table shows the constants used by the Type property.
| Constant |
Value |
CEDB Support |
Description |
| adArray |
0x2000 |
No |
Or'd together with another type to specify that the data is a safe-array of that type. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adBigInt |
20 |
No |
Refer to the OLE DB Programmer's Reference for more details on this type. |
| adBinary |
128 |
No |
Fixed-length binary data |
| adBoolean |
11 |
Yes |
Variant Boolean type. 0 is false and ~0 is true. |
| adBSTR |
8 |
No |
Pointer to a BSTR. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adByRef |
0x4000 |
No |
Or'd together with another type to specify that the data is a pointer to data of the other type. |
| adChar |
129 |
No |
Fixed-length character string. |
| adCurrency |
6 |
No |
Currency type. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adDate |
7 |
Yes |
OLE Automation Date. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adDBDate |
133 |
No |
Database date data structure. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adDBTime |
134 |
No |
Database time data structure. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adDBTimestamp |
135 |
No |
Database timestamp structure. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adDecimal |
14 |
No |
Variant Decimal type. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adDouble |
5 |
Yes |
Double precision floating point number. |
| adEmpty |
0 |
No |
The column type is empty, usually corresponding to a VT_EMPTY type variant. |
| adError |
10 |
No |
32 bit error code. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adGuid |
72 |
No |
Globally Unique Identifier. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adIDispatch |
9 |
No |
Pointer to an IDispatch COM interface. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adInteger |
3 |
Yes |
Exact numeric value, precision 10 scale 0. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adIUnknown |
13 |
No |
Pointer to an IUnknown COM interface. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adLongVarBinary |
205 |
Yes |
Long variable-length binary data. |
| adLongVarChar |
201 |
No |
Long variable-length character string. |
| adLongVarWChar |
203 |
Yes |
Long, wide, variable-length character string. |
| adNull |
1 |
No |
The column type is NULL. |
| adNumeric |
131 |
No |
Numeric type. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adSingle |
4 |
No |
Single precision floating point number. |
| adSmallInt |
2 |
Yes |
Exact numeric value, precision 5 scale 0. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adTinyInt |
16 |
No |
Exact numeric value, precision 3 scale 0. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adUnsignedBigInt |
21 |
No |
Unsigned version of adBigInt. |
| adUnsignedInt |
19 |
Yes |
Unsigned version of adInteger. |
| adUnsignedSmallInt |
18 |
Yes |
Unsigned version of adSmallInt. |
| adUnsignedTinyInt |
17 |
No |
Unsigned version of adTinyInt. |
| adUserDefined |
132 |
No |
User defined data type of variable length. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adVarBinary |
204 |
Yes |
Variable-length binary data. |
| adVarChar |
200 |
No |
Variable-length character string. |
| adVariant |
12 |
No |
OLE Automation VARIANT. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adVarWChar |
202 |
Yes |
Wide variable-length character string. |
| adVector |
0x1000 |
No |
Or'd together with another type to specify that the data is a DBVECTOR structure (Defined in OLE DB) that contains a count of elements and a pointer to data of the other type. Refer to the OLE DB Programmer's Reference for more details on this type. |
| adWChar |
130 |
No |
Wide fixed-length character string. |
Remarks
This property is read-only.
The above list includes all possible constants. Check the provider
documentation to see which constants are supported.
1 ADOCE control documentation,
Copyright 2000 Microsoft Corporation
Previous Page
Next Page