SQLGetConnectAttr
lazarus / 16-Databases

----------------------------------------------------------------------
Grahame Grieve · 2020-10-09 09:42

Why is SQLGetConnectAttr not declared in odbcdyn.inc? (packages/odbc)

SQLSetConnectAttr is defined, so it would seem that SQLGetConnectAttr
should be. Is there a reason, or is this an oversight?

----------------------------------------------------------------------
Grahame Grieve · 2020-10-09 10:14

.. and SQLGetFunctions

----------------------------------------------------------------------
Grahame Grieve · 2020-10-09 10:33

And SQLSetDescField is commented out?

----------------------------------------------------------------------
LacaK · 2020-10-13 05:43

IMO:
- SQLGetConnectAttr and SQLGetFunctions are not added because nobody
requested/needed it up to now
- SQLSetDescField can be uncommented (it was added by my patch as a
new function, but I did not used it so probably I commented it)

You can post request on bug tracker https://bugs.freepascal.org.
If you do not have account I can create request ...
Attached is patch, which adds 3 requested functions.

----------------------------------------------------------------------
Grahame Grieve · 2020-10-17 22:54

Thanks - wonderful. I also use these additional api calls:

SQLDescribeParam
SQLForeignKeys
SQLParamData
SQLGetStmtOption
SQLGetTypeInfo

And these constants:

  SQL_API_ALL_FUNCTIONS = 0;
  SQL_API_ODBC3_ALL_FUNCTIONS = 999;
  SQL_IGNORE = (-6);
  SQL_ATTR_QUERY_TIMEOUT = SQL_QUERY_TIMEOUT;
  SQL_LEN_DATA_AT_EXEC_OFFSET = (-100);
  SQL_DIAG_CURSOR_ROW_COUNT = (-1249);
  SQL_NEED_LONG_DATA_LEN = 111;
  SQL_NAMED = 0;
  SQL_UNNAMED = 1;

  SQL_ATTR_PARAMSET_SIZE = 22;
  SQL_API_SQLPARAMDATA = 48;
  SQL_PC_UNKNOWN = 0;
  SQL_PC_NON_PSEUDO = 1;
  SQL_PC_PSEUDO = 2;
  SQL_ALL_TABLE_TYPES = '%';

though I'm really not sure that the use my codes make of
SQL_LEN_DATA_AT_EXEC_OFFSET make any sense (it works, though, so I'm
not breaking it)

I've attached the code I'm presently using, though I haven't tested it
enough yet.

----------------------------------------------------------------------
LacaK · 2020-10-19 11:36

Some of constants and functions you mentioned were added to TRUNK.

----------------------------------------------------------------------
marcov · 2020-10-19 12:17

Quote from: LacaK on October 19, 2020, 01:36:44 pmSome of constants
and functions you mentioned were added to TRUNK.

(and were merged back to fixes last week)

----------------------------------------------------------------------
LacaK · 2020-10-19 16:18

Marco: but patch to ODBC headers is not merged yet. It was applied
only today

----------------------------------------------------------------------
marcov · 2020-10-19 17:12

Ok, yes, I merged older ODBC patches (and not the parser ones)