datetype.asp

自动化网络办公系统全部源码officeanywheresystem

<%
function fnGetDataTypeConstant(Value)
select case value
	case 8192
fnGetDataTypeConstant="Array"
 	case  20
fnGetDataTypeConstant="BigInt"
	case   128
fnGetDataTypeConstant="Binary"
	case   11
fnGetDataTypeConstant="Boolean"
	case   8 
fnGetDataTypeConstant="BSTR"
	case   136 
fnGetDataTypeConstant="Chapter"
	case   129 
fnGetDataTypeConstant="Char"
	case   6 
fnGetDataTypeConstant="Currency"
	case   7 
fnGetDataTypeConstant="Date"
	case   133 
fnGetDataTypeConstant="DBDate"
	case   134 
fnGetDataTypeConstant="DBTime"
	case   135 
fnGetDataTypeConstant="DBTimeStamp"
	case   14 
fnGetDataTypeConstant="Decimal"
	case   5 
fnGetDataTypeConstant="Double"
	case   0 
fnGetDataTypeConstant="Empty"
	case   10
fnGetDataTypeConstant="Error"
	case   64
fnGetDataTypeConstant="FileTime"
	case  72
fnGetDataTypeConstant="GUID"
	case   9 
fnGetDataTypeConstant="IDispatch"
 
	case   3 
fnGetDataTypeConstant="Integer"
	case   13 
fnGetDataTypeConstant="IUnknown"
 
	case   205
fnGetDataTypeConstant="LongVarBinary"
	case   201
fnGetDataTypeConstant="LongVarChar"
	case   203
fnGetDataTypeConstant="LongVarWChar"
	case   131 
fnGetDataTypeConstant="Numeric"
	case   138
fnGetDataTypeConstant="PropVariant"
	case   4
fnGetDataTypeConstant="Single"
	case   2
fnGetDataTypeConstant="SmallInt"
	case   16
fnGetDataTypeConstant="TinyInt"
	case   21
fnGetDataTypeConstant="UnsignedBigInt"
	case   19
fnGetDataTypeConstant="UnsignedInt"
	case   18
fnGetDataTypeConstant="UnsignedSmallInt"
	case   17
fnGetDataTypeConstant="UnsignedTinyInt"
	case   132
fnGetDataTypeConstant="UserDefined"
	case   204
fnGetDataTypeConstant="VarBinary"
	case   200
fnGetDataTypeConstant="VarChar"
	case   12
fnGetDataTypeConstant="Variant"
 
	case   139
fnGetDataTypeConstant="VarNumeric"
	case   202
fnGetDataTypeConstant="VarWChar"
	case   130 
fnGetDataTypeConstant="WChar"
end select

end function

function fnGetDataTypeDescription(Value)
select case value
	case 8192
fnGetDataTypeConstant="Array (Does not apply to ADOX.)  A flag value, always combined with another data type constant, that indicates an array of that other data type. 	"
	case  20
fnGetDataTypeConstant="BigInt  Indicates an eight-byte signed integer (DBTYPE_I8). "
	case  128
fnGetDataTypeConstant="Binary  Indicates a binary value (DBTYPE_BYTES). "
	case  11
fnGetDataTypeConstant="Boolean  Indicates a boolean value (DBTYPE_BOOL). "
	case  8
fnGetDataTypeConstant="BSTR  Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR). "
	case  136
fnGetDataTypeConstant="Chapter  Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER). "
	case  129
fnGetDataTypeConstant="Char  Indicates a string value (DBTYPE_STR). "
	case  6
fnGetDataTypeConstant="Currency  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. "
	case  7
fnGetDataTypeConstant="Date  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. "
	case  133
fnGetDataTypeConstant="DBDate  Indicates a date value (yyyymmdd) (DBTYPE_DBDATE). "
	case  134
fnGetDataTypeConstant="DBTime  Indicates a time value (hhmmss) (DBTYPE_DBTIME). "
	case  135
fnGetDataTypeConstant="DBTimeStamp  Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP)." 
	case  14
fnGetDataTypeConstant="Decimal  Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL). "
	case  5
fnGetDataTypeConstant="Double  Indicates a double-precision floating-point value (DBTYPE_R8). "
	case  0
fnGetDataTypeConstant="Empty  Specifies no value (DBTYPE_EMPTY). "
	case  10
fnGetDataTypeConstant="Error  Indicates a 32-bit error code (DBTYPE_ERROR). "
	case  64
fnGetDataTypeConstant="FileTime  Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). "
	case  72
fnGetDataTypeConstant="GUID  Indicates a globally unique identifier (GUID) (DBTYPE_GUID). "
	case  9
fnGetDataTypeConstant="IDispatch  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."
 
	case  3
fnGetDataTypeConstant="Integer  Indicates a four-byte signed integer (DBTYPE_I4). "
	case  13
fnGetDataTypeConstant="IUnknown  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."
 
	case  205
fnGetDataTypeConstant="LongVarBinary  Indicates a long binary value (Parameter object only). "
	case  201
fnGetDataTypeConstant="LongVarChar  Indicates a long string value (Parameter object only). "
	case  203
fnGetDataTypeConstant="LongVarWChar  Indicates a long null-terminated Unicode string value (Parameter object only). "
	case  131
fnGetDataTypeConstant="Numeric  Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC). "
	case  138
fnGetDataTypeConstant="PropVariant  Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT). "
	case  4
fnGetDataTypeConstant="Single  Indicates a single-precision floating-point value (DBTYPE_R4). "
	case  2
fnGetDataTypeConstant="SmallInt  Indicates a two-byte signed integer (DBTYPE_I2). "
	case  16
fnGetDataTypeConstant="TinyInt  Indicates a one-byte signed integer (DBTYPE_I1). "
	case  21
fnGetDataTypeConstant="UnsignedBigInt  Indicates an eight-byte unsigned integer (DBTYPE_UI8). "
	case  19
fnGetDataTypeConstant="UnsignedInt  Indicates a four-byte unsigned integer (DBTYPE_UI4). "
	case  18
fnGetDataTypeConstant="UnsignedSmallInt  Indicates a two-byte unsigned integer (DBTYPE_UI2). "
	case  17
fnGetDataTypeConstant="UnsignedTinyInt  Indicates a one-byte unsigned integer (DBTYPE_UI1). "
	case  132
fnGetDataTypeConstant="UserDefined  Indicates a user-defined variable (DBTYPE_UDT). "
	case  204
fnGetDataTypeConstant="VarBinary  Indicates a binary value (Parameter object only). "
	case  200
fnGetDataTypeConstant="VarChar  Indicates a string value (Parameter object only). "
	case  12
fnGetDataTypeConstant="Variant  Indicates an Automation Variant (DBTYPE_VARIANT). Note   This data type is currently not supported by adO. Usage may cause unpredictable results."
 
	case  139
fnGetDataTypeConstant="VarNumeric  Indicates a numeric value (Parameter object only). "
	case  202
fnGetDataTypeConstant="VarWChar  Indicates a null-terminated Unicode character string. "
	case  130
fnGetDataTypeConstant="WChar  Indicates a null-terminated Unicode character string (DBTYPE_WSTR). "
end select
end function
%>