Re: SQLExecute returns 0 rows with BoolsAsChar=1

Поиск
Список
Период
Сортировка
Искать
От
Hiroshi Inoue
Тема
Re: SQLExecute returns 0 rows with BoolsAsChar=1
Дата
Msg-id
514ED061.10906@tpf.co.jp
Ответ на
Список
Дерево обсуждения
SQLExecute returns 0 rows with BoolsAsChar=1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: SQLExecute returns 0 rows with BoolsAsChar=1 Hiroshi Inoue <inoue@tpf.co.jp>
(2013/03/22 1:42), Heikki Linnakangas wrote:
> 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.

Thanks.
I can reproduce it now when I turn off the *Server side prepare* option
or turn on the *Use Declare/Fetch* option.

Attached is a patch to fix the bug.

regards,
Hiroshi Inoue
В списке pgsql-odbc по дате отправления
От: BGoebel
Дата:
Сообщение: Re: Issue with ALTER Table.
От: Heikki Linnakangas
Дата:
FAQ