Re: PGAPI_SetPos error

Thu, Aug 03, 2006 at 08:57:39AM -0700, Patrick Hatcher wrote:
> ODBC v 8.1.2
>
> server.  When we try to update the table, we receive the following error:
> ERROR: Error updating table entry: Only SQL_POSITION/REFRESH is supported
> for PGAPI_SetPos
>
> Any suggestion as to what I can do?

Hello

The psqlODBC 08.01.XXXX doesn't support updateable cursors. I know there
is such option. But it doesn't work. Please try 08.02.0002 and then
replace the dlls with once from:

http://www.geocities.jp/inocchichichi/psqlodbc/index.html

It's the latest. The version there is 07.03.XXXX but you should use it.
I don't know why Hiroshi use that numbering.

Regards,

Luf