Re: SQLTables and szTableRemarks field? - Mailing list pgsql-odbc

From Alex Goncharov
Subject Re: SQLTables and szTableRemarks field?
Date
Msg-id E1MNbj1-000MCX-As@daland.home
Whole thread Raw
In response to SQLTables and szTableRemarks field?  (Lothar Behrens <lothar.behrens@lollisoft.de>)
Responses Re: SQLTables and szTableRemarks field?  (Lothar Behrens <lothar.behrens@lollisoft.de>)
List pgsql-odbc
,--- You/Lothar (Mon, 6 Jul 2009 00:37:31 +0200) ----*
| When reading out tables with SQLTables I did not get the remarks field.
|
| Why is this happen or is it unimplemented?

Per the documentation available online, it is not.

| I bind the columns as follows:
|
|     SQLBindCol(hstmt, 1, SQL_C_CHAR, szTableCatalog, TAB_LEN,
| &cbTableCatalog);
|     SQLBindCol(hstmt, 2, SQL_C_CHAR, szTableSchema, TAB_LEN,
| &cbTableSchema);
|     SQLBindCol(hstmt, 3, SQL_C_CHAR, szTableName, TAB_LEN, &cbTableName);
|     SQLBindCol(hstmt, 4, SQL_C_CHAR, szTableType, TAB_LEN, &cbTableType);
|     SQLBindCol(hstmt, 5, SQL_C_CHAR, szTableRemarks, REM_LEN,
| &cbTableRemarks);

The fifth column of the `information_schema.tables' table is called,
in fact, `self_referencing_column_name', and "applies to a feature not
available in PostgreSQL".

-- Alex -- alex-goncharov@comcast.net --

pgsql-odbc by date:

Previous
From: Lothar Behrens
Date:
Subject: SQLTables and szTableRemarks field?
Next
From: Ger
Date:
Subject: GetPrivateProfileString