Re: SQLExecute returns 0 rows with BoolsAsChar=1 - Mailing list pgsql-odbc

From Heikki Linnakangas
Subject Re: SQLExecute returns 0 rows with BoolsAsChar=1
Date
Msg-id 514B3870.2060208@vmware.com
Whole thread Raw
In response to Re: SQLExecute returns 0 rows with BoolsAsChar=1  (Hiroshi Inoue <inoue@tpf.co.jp>)
Responses Re: SQLExecute returns 0 rows with BoolsAsChar=1
List pgsql-odbc
On 21.03.2013 14:19, Hiroshi Inoue wrote:
> (2013/03/19 7:25), Heikki Linnakangas wrote:
>> If you SQLPrepare a query, and bind a VARCHAR parameter with column_size
>> of exactly 5, and you have BoolsAsChar=1 (which is the default), the
>> subsequent SQLExecute will return 0 rows.
>
> Hmm I can't reproduce it here.
> Could you send me the Mylog output of the case?

Sure. Here's a test program to reproduce it, and the mylog output from
running it. It should print:

got result: foobar

But due to the bug, you get:

SQLFetch returned SQL_NO_DATA

- Heikki

Attachment

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: SQLExecute returns 0 rows with BoolsAsChar=1
Next
From: Heikki Linnakangas
Date:
Subject: Re: Issue with ALTER Table.