Re: SQLSetPos - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: SQLSetPos
Date
Msg-id 005601c2fa2d$72a20bd0$0e283ddb@PbgX
Whole thread Raw
In response to SQLSetPos  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-odbc
> -----Original Message-----
> From: Dave Page [mailto:dpage@vale-housing.co.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.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: SQLSetPos
Next
From: "Dave Page"
Date:
Subject: Re: SQLSetPos