FreeTDS Development Group

[Peter Deacon <peterd AT iea-software.com>]

/w sybase (TDS 6.0) created an error that should fail but doesen't, not
even SQL_SUCCESS_WITH_INFO.

For example: SELECT DATEADD(dd,-100000,getdate())

It's level is 16 and when I run it from isqlw it aborts the query.

The message appears in the message chain but looking around it's sent to
the odbc message callback sometime after SQLExecDirect gets called...
This fixed it for me.

In odbc.c::_SQLExecute

Changed..

case TDS_COMPUTEFMT_RESULT:
case TDS_ROWFMT_RESULT:
        done = 1;
        break;

to:

case TDS_COMPUTEFMT_RESULT:
case TDS_ROWFMT_RESULT:
        if (tds->state == TDS_COMPLETED)
                done = 1;
        break;

Have Fun!
Peter