From: | Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | SQLTables and szTableRemarks field? |
Date: | 2009-07-05 22:37:31 |
Message-ID: | EB29FF97-957A-4B17-9FE0-7D39A3C8B75F@lollisoft.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
I am using unixODBC driver 2.2.12 on Mac OSX 10.5.2 or Windows XP and
the pgODBC driver 08.03.0400.
When reading out tables with SQLTables I did not get the remarks field.
Why is this happen or is it unimplemented?
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);
And use either
retcode = SQLTables(hstmt, NULL, 0, (unsigned char*) schema,
strlen(schema), NULL, 0, NULL, 0);
or
retcode = SQLTables(hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0);
Any ideas?
Thanks
Lothar
-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Goncharov | 2009-07-06 00:06:27 | Re: SQLTables and szTableRemarks field? |
Previous Message | Ger | 2009-07-02 21:46:43 | GetPrivateProfileString |