GetODBCInfo (open)

Get the ODBC driver information and capabilities

Syntax

LOADLIB "wh::dbase/odbc.whlib";

RECORD FUNCTION GetODBCInfo(INTEGER transaction)

Parameters

INTEGER transaction

ODBC transaction id

Return value

RECORD

A record explaining the ODBC capabilities of a transaction

cap_bind

Every ODBC driver should support column binding, which is faster, but disabling column binding may help track down problems with an individual ODBC driver

cap_getdata_any_column

SQL_GD_ANY_COLUMN - If available, the ordering of selected columns in raw commands should have no effect on speed. If unavailable, larger columns should be selected after smaller columns.

cap_getdata_when_bound

SQL_GD_BOUND - If available, both native and raw commands will be faster because transferring small blobs and strings requires less ODBC driver communication

cap_setpos_modify

SQL_POS_UPDATE and SQL_POS_DELETE - If available, HareScript native UPDATE and DELETE will be faster because they can fetch blocks instead of single rows

cap_setpos_position

SQL_POS_POSITION - If available, HareScript native SELECT will be faster because they can fetch blocks instead of single rows

database_application

Application name of the connected database

database_name

Name of the connected database

database_version

Version of the connected database

driver_name

Name of the driver used to connect

driver_odbc_version

ODBC Version of the driver used to connect

driver_version

Version of the driver used to connect

dynamic_attributes

A string listing the attributes supported by dynamic cursors

forward_only_attributes

A string listing the attributes supported by forward-only cursors

keyset_driven_attributes

A string listing the attributes supported by keyset-driven cursors

need_long_data_length

True if this database needs to know the length beforehand of LONG data passed to it

pos_options

A string listing the options offered by SetPos

readonly

True if this data source is read-only

scroll_options

A string listing the capabilities of cursors

static_attributes

A string listing the attributes supported by static cursors

Description

This function returns information about the settings and capabilities of an ODBC transaction. It is intended for debugging purposes and the use of raw commands (SendODBCCommand and SendODBCTypedCommand) only - the native HareScript SQL commands will automatically cope with and simulate any missing functionality.