> -----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;
}