Re: problem with multiple result sets

> -----Original Message-----
> From: Albert Graef [mailto:Dr.Graef@t-online.de]
> Sent: Sunday, September 21, 2003 8:14 PM
> To: Hiroshi Inoue
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] problem with multiple result sets
>
>
> Hiroshi Inoue wrote:
> > Oh I see. I would try to fix it. However, I'm not sure how to
> > fix it in your *nix environment.
>
> Hi, thanks a lot for your reply. If the fix is in the driver,
> I'll just
> take the diffs and apply them to the driver sources (or download the
> updated driver sources) and recompile, that shouldn't be a
> problem. Or
> would I have to change the code of the application?

I can't make diff now, sorry.
In PGAPI_MoreResults() in results.c, please try to insert
the 2 lines between /* insert the following ... */ and /* insert end */.

RETCODE        SQL_API
PGAPI_MoreResults(
                  HSTMT hstmt)
{
    const char *func = "PGAPI_MoreResults";
    StatementClass    *stmt = (StatementClass *) hstmt;
    QResultClass    *res;

    mylog("%s: entering...\n", func);
    if (stmt && (res = SC_get_Curres(stmt)))
        SC_set_Curres(stmt, res->next);
    if (res = SC_get_Curres(stmt), res)
    {
        stmt->diag_row_count = res->recent_processed_row_count;
        /* insert the following 2 lines */
        stmt->rowset_start = -1;
        stmt->currTuple = -1;
        /* insert end */
         return SQL_SUCCESS;
    }
    return SQL_NO_DATA_FOUND;
}