From: | "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: SQLSetPos |
Date: | 2003-04-05 16:05:00 |
Message-ID: | 00e901c2fb8d$1ccf8dc0$0e283ddb@PbgX |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp]
> > > -----Original Message-----
> > > From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > >
> > > Hi Hiroshi,
> > >
> > > I've had a query about support for SQLSetPos(SQL_UPDATE) in
> > psqlODBC.
> > > Upon examination of the code there seems to be some there
> to handle
> > > SQL_UPDATE, however the function exits with an error (Only
> > > SQL_POSITION/REFRESH is supported for PGAPI_SetPos) before
> > any of that
> > > code is ever reached.
> > >
> > > Do you know if that's an oversight, or is the code that's
> there not
> > > ready for use yet?
> >
> > You can use SQLSetPos(SQL_UPDATE) if you compiled the driver
> > with DRIVER_CURSOR_IMPLEMENT #defined(the current makefile s
> > in cvs already #define it) and turn on the *Updatable
> > cursors* DSN option.
>
> OK thanks. I'm confused by the following code towards the beginning of
> PGAPI_SetPos which is not in any #ifdef block that I can see:
There's
else
#endif /* DRIVER_CURSOR_IMPLEMENT */
just before the below code. Please pay attention to the above *else*.
> if (fOption != SQL_POSITION && fOption != SQL_REFRESH)
> {
> SC_set_error(stmt, STMT_NOT_IMPLEMENTED_ERROR, "Only
> SQL_POSITION/REFRESH is supported for PGAPI_SetPos");
> SC_log_error(func, "", stmt);
> return SQL_ERROR;
> }
>
> Won't that make the function exit with an error before an
> SQL_UPDATE is
> handled?
regards,
Hiroshi Inoue
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-04-05 19:06:41 | Re: SQLSetPos |
Previous Message | Richard Huxton | 2003-04-04 11:32:34 | Re: Problem with odbc.sql |