Skip site navigation (1) Skip section navigation (2)

SQLTables and szTableRemarks field?

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

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,  
	SQLBindCol(hstmt, 2, SQL_C_CHAR, szTableSchema, TAB_LEN,  
	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,  

And use either

	retcode = SQLTables(hstmt, NULL, 0, (unsigned char*) schema,  
strlen(schema), NULL, 0, NULL, 0);


	retcode = SQLTables(hstmt, NULL, 0, NULL, 0, NULL, 0, NULL, 0);

Any ideas?



-- | Rapid Prototyping | XSLT Codegeneration |
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen


pgsql-odbc by date

Next:From: Alex GoncharovDate: 2009-07-06 00:06:27
Subject: Re: SQLTables and szTableRemarks field?
Previous:From: GerDate: 2009-07-02 21:46:43
Subject: GetPrivateProfileString

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group