SQLTables and szTableRemarks field? - Mailing list pgsql-odbc

From Lothar Behrens
Subject SQLTables and szTableRemarks field?
Date
Msg-id EB29FF97-957A-4B17-9FE0-7D39A3C8B75F@lollisoft.de
Whole thread Raw
Responses Re: SQLTables and szTableRemarks field?  (Alex Goncharov <alex-goncharov@comcast.net>)
List 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









pgsql-odbc by date:

Previous
From: Assaf Lavie
Date:
Subject: ODBC Drivers for 64 bit process on Windows XP
Next
From: Alex Goncharov
Date:
Subject: Re: SQLTables and szTableRemarks field?