Re: SQLColAttributes and SQL_DESC_NULLABLE

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Ludek Finstrle
> Sent: 06 December 2005 22:55
> To: Robert Jireš
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] SQLColAttributes and SQL_DESC_NULLABLE
>
> > 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?
>
> I attach patch which solve this problem. Thanks to Robert to point
> it and find the solution.
>
> I don't know if it works with declare/fetch or server side prepare
> (maybe other options could break it too). Please is there someone
> who can test it? I can upload Windows DLL to test it if you want.

No regressions I can find - patch applied, thanks!

*However*, whilst testing I did find an issue with SQLTables that seems surprisingly similar to the one you fixed
before.It's pretty easy to recreate in the Microsoft test suite. 

- Connect to a data source with Declare/Fetch enabled.
- SQLExecDirect "SELECT * FROM pg_class"
- Get Data All (from the results menu)
- SQLTables
- Get Data All

It never stops retrieving data! Seems that you need to do the SQLExecDirect first - SQLExecute doesn't trigger the
problem.SQLColumns is similarly affected - perhaps there are more as well. 

Wanna take a look, or shall I log a bug until one of us gets time?

Regards, Dave.