Postgres Pro
Downloads
Home   >   mailing lists

SQLNumResultCol set to 0 for query using common table expression - broken again - Mailing list pgsql-odbc

From the6campbells
Subject SQLNumResultCol set to 0 for query using common table expression - broken again
Date
Msg-id AANLkTind0FLG+s2-3WETbroryj3R=Hh5r+zs9z668b58@mail.gmail.com
Whole thread Raw
Responses Re: SQLNumResultCol set to 0 for query using common table expression - broken again  (the6campbells <the6campbells@gmail.com>)
List pgsql-odbc
Tree view
This is issue was reported previously and fixed in 8.4.0101 but see it in the 9.0 driver.


with t_cte ( cte1,cte2,cte3 ) as ( select tset1.rnum, tset1.c1, tset1.c2 from tset1 ) select * from t_cte


SQLPrepare:
In: StatementHandle = 0x00841B38, StatementText = "with t_cte ( cte1,cte2,cte3 ) as ( select tset1.rn...", TextLength = 105
Return: SQL_SUCCESS=0
SQLNumResultCols:
In: StatementHandle = 0x00841B38, ColumnCountPtr = 0x00095428
Return: SQL_SUCCESS=0
Out: *ColumnCountPtr = 0


 

pgsql-odbc by date:

Previous
From: the6campbells
Date:
Subject: 9.0.01 ODBC driver return values changed for sqlGetTypeInfo
Next
From: the6campbells
Date:
Subject: Re: SQLNumResultCol set to 0 for query using common table expression - broken again