Re: SQLTables and szTableRemarks field?

From: Alex Goncharov <alex-goncharov(at)comcast(dot)net>
To: Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLTables and szTableRemarks field?
Date: 2009-07-06 00:06:27
Message-ID: E1MNbj1-000MCX-As@daland.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)comcast(dot)net --

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Lothar Behrens 2009-07-06 06:42:27 Re: SQLTables and szTableRemarks field?
Previous Message Lothar Behrens 2009-07-05 22:37:31 SQLTables and szTableRemarks field?