GetColumnDataTypes()


" "

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.