Re: Cursor for a positioned update: "cursor does not exist" error - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Cursor for a positioned update: "cursor does not exist" error
Date
Msg-id 519E1787.1070903@tpf.co.jp
Whole thread Raw
In response to Cursor for a positioned update: "cursor doesnot exist" error  (Sam Varshavchik <mrsam@courier-mta.com>)
List pgsql-odbc
Hi Sam,

(2013/05/23 7:11), Sam Varshavchik wrote:
> I'm using postgresql-odbc-09.01.0200 with postgresl-9.2.4
>
> According to the documention for SQLSetCursorName
> (http://msdn.microsoft.com/en-us/library/windows/desktop/ms711707%28v=vs.85%29.aspx)
>
> I don't really need to use it, and ODBC will use a default name.
>
> With unixODBC and a Postgresql connection handle, SQLGetInfo() shows
> SQL_CA1_POS_UPDATE capability for SQL_STATIC_CURSOR_ATTRIBUTES1, and
> SQL_KEYSET_CURSOR_ATTRIBUTES1.

SQL_CA1_POS_UPDATE stands for thr capability about SQLSetPos function
not about positioned update.
Maybe we had better not support SQLSetCursorName to avoid the confusion.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: ODBC does not handle WITH clause
Next
From: Joe Conway
Date:
Subject: Re: ODBC does not handle WITH clause