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 --
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? |