FreeTDS Development Group

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

This should be about right for SQLRowCount..

RowCount is normally the number of rows effected by update ops.
The odbc documentation mentions if rowcount is not avaliable you should
return -1.

With the driver rowcounts for SELECTs are not avaliable until after you've
downloaded all rows from the database.  Set -1 initially so those who
check for a count initially won't be confused.

Have Fun!
Peter

SQLRowCount(SQLHSTMT hstmt, SQLINTEGER FAR * pcrow)
...

        tds = stmt->hdbc->tds_socket;
        if (tds->rows_affected == TDS_NO_COUNT)
                {
                if (tds->res_info != NULL)
                        {
                        if (tds->res_info->row_count == 0)
                                *pcrow = -1;
                        else
                                *pcrow = tds->res_info->row_count;
                        }
                else
                        *pcrow = -1;
                }
        else
                *pcrow = tds->rows_affected;
        return SQL_SUCCESS;

...