
short GetColumnDataValue(long QueryID, long Index )
Description
This function returns an array of the data types for all the columns
referenced in the specified query. You use this function in conjunction
with GetColumnCount(), which will get
the number of columns referneced in the specified query.
Parameters
Name
| Description
|
QueryID
| The ID of the query, as returned from InitializeQuery().
|
DataTypes
|
A pointer to a VARIANT in which you want to store the result
array of the SQL data types.
- 384 (RSDT_DATE) -- Date
- 388 (RSDT_TIME) -- Time
- 392 (RSDT_TIMESTAMP) -- Timestamp
- 396 (RSDT_DATALINK) -- Datalink
- 404 (RSDT_BLOB) -- Binary large object
- 408 (RSDT_CLOB) -- Character large object
- 412 (RSDT_DBCLOB) -- Double-byte character large object
- 448 (RSDT_VARCHAR) -- Variable length character string
- 452 (RSDT_CHAR) -- Character string
- 456 (RSDT_LONGVARCHAR) -- Long varying length character
string
- 464 (RSDT_VARGRAPHIC) -- Varying length graphic string
- 468 (RSDT_GRAPHIC) -- Graphic string
- 472 (RSDT_LONGVARGRAPHIC) -- Long varying length graphic
string
- 480 (RSDT_FLOAT) -- Floating point number
- 484 (RSDT_DECIMAL) -- Decimal number
- 492 (RSDT_BIGINT) -- 8-byte integer
- 496 (RSDT_INTEGER) -- 4-byte integer
- 500 (RSDT_SMALLINT) -- 2-byte integer
- 916 (RSDT_BLOBFILEFREF) -- Binary large object file
reference
- 920 (RSDT_CLOBFILEREF) -- Character large object file
reference
- 924 (RSDT_DBCLOBFILEREF) -- Double-byte character large
object file reference
- 904 (RSDT_ROWID) -- Row identifier
- 960 (RSDT_BLOBLOCATOR) -- Binary large object locator
- 964 (RSDT_CLOBLOCATOR) -- Character large object locator
- 968 (RSDT_DBCLOBLOCATOR) -- Double-byte large object
locator
|
Return Value
The return value will be zero, if successful and non-zero if
unsuccessful. If the return value is non-zero, you can call GetLastErrorString(), or GetLastErrorType() to get additional error
information.