FreeTDS Development Group

["Frediano Ziglio" <freddy77 AT gmail.com>]

2007/10/31, Adriano Duarte <adriano.didi AT gmail.com>:
>
>    Please could someone here help me??
>
>    I have this problem:
>
> isql -v coad user password
>   SQL> select SENHA from ura_instant where SENHA ='24772375'
> +---------+
> | SENHA   |
> +---------+
> | 24772375|
> | 24772375|
> +---------+
> SQLRowCount returns 2
> 2 rows fetched
> SQL> select SENHA from ura_instant where SENHA ='24772375'
> +------------+
> |            |
> +------------+
> +------------+
> SQLRowCount returns 0
> SQL> select SENHA from ura_instant where SENHA ='24772375'
> SQLRowCount returns -1
> SQL> select SENHA from ura_instant where SENHA ='24772375'
> +---------+
> | SENHA   |
> +---------+
> | 24772375|
> | 24772375|
> +---------+
> SQLRowCount returns 2
> 2 rows fetched
>
>     I have tried to install both freetds-0.64-6.rpm and
> freetds-stable.tgzand it's all the same.



I remember this problem but I thought was very old..
I think that enabling unixodbc trace would be very helpful. You should see
from SQLFetch results if the problem reside in our driver or in DM.
If query do not return a warning probably it's our driver :(... but as said
it's quite strange...

freddy77