Re: problem with multiple result sets

> -----Original Message-----
> From: Albert Graef [mailto:Dr(dot)Graef(at)t-online(dot)de]
> Sent: Sunday, September 21, 2003 8:14 PM
> To: Hiroshi Inoue
> Cc: pgsql-odbc(at)postgresql(dot)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;
}