How to pass a long data type to a ADO.parameter?

[mcaron]

I want to know how to pass a long data type to an ADO.parameter object. For instance if your parameter is a string you can set the Type property of the parameter to adVarChar or if its integer, Type=adInteger etc... Which constant would be used if your parameter is of data type long?

Thanks,

[Jorge Ramirez]

I send you the complete text. I get it for the MSDN Library. I hope this help you.

Jorge Ramirez.
[email protected]
[email protected]


Contents Index Topic Contents


Type Property - ADO
Indicates the operational type or data type of a Parameter, Field, or Property object.

Applies To

Field, Parameter, Property

Settings and Return Values

Sets or returns one of the following DataTypeEnum values. The corresponding OLE DB type indicator is shown in parentheses in the description column of the following table. For more information on OLE DB data types, see Chapter 10 and Appendix A of the OLE DB 1.1 Programmer's Reference. Constant Description

adArray
Or'd together with another type to indicate that the data is a safe-array of that type (DBTYPE_ARRAY).

adBigInt An 8-byte signed integer (DBTYPE_I8).

adBinary A binary value (DBTYPE_BYTES).

adBoolean A Boolean value (DBTYPE_BOOL).

adByRef Or'd together with another type to indicate that the data is a pointer to data of the other type (DBTYPE_BYREF).

adBSTR A null-terminated character string (Unicode) (DBTYPE_BSTR).

adChar A String value (DBTYPE_STR).

adCurrency A currency value (DBTYPE_CY). Currency is a fixed-point number with 4 digits to the right of the decimal point. It is stored in an 8-byte signed integer scaled by 10,000.

adDate 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 A date value (yyyymmdd) (DBTYPE_DBDATE).

adDBTime A time value (hhmmss) (DBTYPE_DBTIME).

adDBTimeStamp A date-time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP).

adDecimal An exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL).
adDouble A double-precision floating point value (DBTYPE_R8).

adEmpty No value was specified (DBTYPE_EMPTY).

adError A 32-bit error code (DBTYPE_ERROR).

adGUID A globally unique identifier (GUID) (DBTYPE_GUID).

adIDispatch A pointer to an IDispatch interface on an OLE object (DBTYPE_IDISPATCH).

adInteger A 4-byte signed integer (DBTYPE_I4).

adIUnknown A pointer to an IUnknown interface on an OLE object (DBTYPE_IUNKNOWN).

adLongVarBinary A long binary value (Parameter object only).

adLongVarChar A long String value (Parameter object only).

adLongVarWChar A long null-terminated string value (Parameter object only).

adNumeric An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).

adSingle A single-precision floating point value (DBTYPE_R4).

adSmallInt A 2-byte signed integer (DBTYPE_I2).

adTinyInt A 1-byte signed integer (DBTYPE_I1).

adUnsignedBigInt An 8-byte unsigned integer (DBTYPE_UI8).

adUnsignedInt A 4-byte unsigned integer (DBTYPE_UI4).

adUnsignedSmallInt A 2-byte unsigned integer (DBTYPE_UI2).

adUnsignedTinyInt A 1-byte unsigned integer (DBTYPE_UI1).

adUserDefined A user-defined variable (DBTYPE_UDT).

adVarBinary A binary value (Parameter object only).

adVarChar A String value (Parameter object only).

adVariant An Automation Variant (DBTYPE_VARIANT).

adVector Or'd together with another type to indicate that the data is a DBVECTOR structure, as defined by OLE DB, that contains a count of elements and a pointer to data of the other type (DBTYPE_VECTOR).

adVarWChar A null-terminated Unicode character string (Parameter object only).

adWChar A null-terminated Unicode character string (DBTYPE_WSTR).



Remarks

For Parameter objects, the Type property is read/write. For all other objects, the Type property is read-only.

[chris_boebel]

the short answer: declare it as type BIGINT.