SQLColAttributes and SQL_DESC_NULLABLE - Mailing list pgsql-odbc

From Robert Jireš
Subject SQLColAttributes and SQL_DESC_NULLABLE
Date
Msg-id 438FA306.4070503@centrum.cz
Whole thread Raw
Responses Re: SQLColAttributes and SQL_DESC_NULLABLE  (Ludek Finstrle <luf@pzkagis.cz>)
Re: SQLColAttributes and SQL_DESC_NULLABLE  (Ludek Finstrle <luf@pzkagis.cz>)
List 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


pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: Re: Annoying problem with UseDeclareFetch
Next
From: Ludek Finstrle
Date:
Subject: Re: Application crash after error - please help