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

SQLColAttributes and SQL_DESC_NULLABLE

From: Robert JireŇ° <robert(dot)jires(at)centrum(dot)cz>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLColAttributes and SQL_DESC_NULLABLE
Date: 2005-12-02 01:27:34
Message-ID: 438FA306.4070503@centrum.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
Hello,
I'm using .Net Odbc Data Provider, ODBC driver 8.1.x and PostgreSQL 8.1.0.
To find out whether column can be null, the .NET calls ODBC function 
SQLColAttributes. Problem is, that this function allways returns  
SQL_NULLABLE, even for columns declared as NOT NULL. I tried to enable 
"Parse Statements" option of the driver, but it didn't help.
I downloaded the latest sources, compiled them to see what's going on 
inside and found this:
It seems that for SQLColAttributes to return something else than 
SQL_NULLABLE, "Parse Statements" option MUST be turned on. Am i right?
For some reason stmt->manual_result  is true, which causes that the 
statement is not parsed. What does this stmt->manual_result  mean?

Thanks in advance.

Robert Jires


Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-02 09:05:30
Subject: Re: Application crash after error - please help
Previous:From: Dave PageDate: 2005-12-01 20:47:20
Subject: Re: Annoying problem with UseDeclareFetch

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