검색결과 리스트
VBA에 해당되는 글 1건
- 2009.05.06 DataTypeEnum - ADODB.Command
글
CreateParameter (Name, Type, Direction, Size, Value)
1.Name
2.Type
3.Direction
4.Size
5.Value
1.Name
2.Type
3.Direction
4.Size
5.Value
Constant | Value | Description |
---|---|---|
AdArray |
0x2000 |
A flag value, always combined with another data type constant, that indicates an array of the other data type. Does not apply to ADOX. |
adBigInt |
20 |
Indicates an eight-byte signed integer (DBTYPE_I8). |
adBinary |
128 |
Indicates a binary value (DBTYPE_BYTES). |
adBoolean |
11 |
Indicates a Boolean value (DBTYPE_BOOL). |
adBSTR |
8 |
Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR). |
adChapter |
136 |
Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER). |
adChar |
129 |
Indicates a string value (DBTYPE_STR). |
adCurrency |
6 |
Indicates a currency value (DBTYPE_CY). Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000. |
adDate |
7 |
Indicates a date value (DBTYPE_DATE). A date is stored as a double, the whole part of which is the number of days since December 30, 1899, and the fractional part of which is the fraction of a day. |
adDBDate |
133 |
Indicates a date value (yyyymmdd) (DBTYPE_DBDATE). |
adDBTime |
134 |
Indicates a time value (hhmmss) (DBTYPE_DBTIME). |
adDBTimeStamp |
135 |
Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP). |
adDecimal |
14 |
Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL). |
adDouble |
5 |
Indicates a double-precision floating-point value (DBTYPE_R8). |
adEmpty |
0 |
Specifies no value (DBTYPE_EMPTY). |
adError |
10 |
Indicates a 32-bit error code (DBTYPE_ERROR). |
adFileTime |
64 |
Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). |
adGUID |
72 |
Indicates a globally unique identifier (GUID) (DBTYPE_GUID). |
adIDispatch |
9 |
Indicates a pointer to an IDispatch interface on a COM object (DBTYPE_IDISPATCH). Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
adInteger |
3 |
Indicates a four-byte signed integer (DBTYPE_I4). |
adIUnknown |
13 |
Indicates a pointer to an IUnknown interface on a COM object (DBTYPE_IUNKNOWN). Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
adLongVarBinary |
205 |
Indicates a long binary value. |
adLongVarChar |
201 |
Indicates a long string value. |
adLongVarWChar |
203 |
Indicates a long null-terminated Unicode string value. |
adNumeric |
131 |
Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). |
adPropVariant |
138 |
Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT). |
adSingle |
4 |
Indicates a single-precision floating-point value (DBTYPE_R4). |
adSmallInt |
2 |
Indicates a two-byte signed integer (DBTYPE_I2). |
adTinyInt |
16 |
Indicates a one-byte signed integer (DBTYPE_I1). |
adUnsignedBigInt |
21 |
Indicates an eight-byte unsigned integer (DBTYPE_UI8). |
adUnsignedInt |
19 |
Indicates a four-byte unsigned integer (DBTYPE_UI4). |
adUnsignedSmallInt |
18 |
Indicates a two-byte unsigned integer (DBTYPE_UI2). |
adUnsignedTinyInt |
17 |
Indicates a one-byte unsigned integer (DBTYPE_UI1). |
adUserDefined |
132 |
Indicates a user-defined variable (DBTYPE_UDT). |
adVarBinary |
204 |
Indicates a binary value. |
adVarChar |
200 |
Indicates a string value. |
adVariant |
12 |
Indicates an Automation Variant (DBTYPE_VARIANT). Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
adVarNumeric |
139 |
Indicates a numeric value. |
adVarWChar |
202 |
Indicates a null-terminated Unicode character string. |
adWChar |
130 |
Indicates a null-terminated Unicode character string (DBTYPE_WSTR). |
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 |
내 블로그 - 관리자 홈 전환 |
Q
Q
|
---|---|
새 글 쓰기 |
W
W
|
글 수정 (권한 있는 경우) |
E
E
|
---|---|
댓글 영역으로 이동 |
C
C
|
이 페이지의 URL 복사 |
S
S
|
---|---|
맨 위로 이동 |
T
T
|
티스토리 홈 이동 |
H
H
|
단축키 안내 |
Shift + /
⇧ + /
|
* 단축키는 한글/영문 대소문자로 이용 가능하며, 티스토리 기본 도메인에서만 동작합니다.
RECENT COMMENT