Re: SQLExecute returns 0 rows with BoolsAsChar=1

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLExecute returns 0 rows with BoolsAsChar=1
Date: 2013-03-21 16:42:24
Message-ID: 514B3870.2060208@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
colsize5.c text/x-csrc 2.7 KB
mylog_heikki23223.log text/x-log 16.1 KB

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2013-03-22 10:03:33 Re: Issue with ALTER Table.
Previous Message Hiroshi Inoue 2013-03-21 12:19:08 Re: SQLExecute returns 0 rows with BoolsAsChar=1