Message-Id: <36965E2D.12FEDD2C@insightdist.com>
Date: Fri, 08 Jan 1999 14:36:13 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: "pgsql-interfaces@hub.org" <pgsql-interfaces@hub.org>
Cc: "pgsql-announce@postgreSQL.org" <pgsql-announce@postgreSQL.org>
Subject: NEW ODBC DRIVER v06-40-0004 supports Bookmarks!
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

There is a new odbc driver at our website
http://www.insightdist.com/psqlodbc.

This version fully supports bookmarks!   It is not all that big of a
deal, because the bookmark I am using is just a row number for now, so
SQLExtendedFetch(SQL_FETCH_ABSOLUTE) would be equivalent.  But it is
great for applications that already depend upon bookmark functionality
or would like to be future compatible if the driver ever uses more
sophisticated cursor methods, where the bookmark might map to a key.

Bookmarks can be retrieved through any of the following methods:
SQLGetData on column 0 with SQL_C_BOOKMARK type
SQLGetStmtOption with SQL_GET_BOOKMARK
SQLBindCol on column 0 with SQL_C_BOOKMARK type along with
SQLExtendedFetch (not SQLFetch)

A rowset can then be positioned using SQLExtendedFetch with the
SQL_FETCH_BOOKMARK option by passing the bookmark as the irow
argument.   Rowsets larger than 1 are supported with bookmarks as well
as with row-wise or column-wise binding.   SQLSetPos can also be used to
position to a row within a rowset to retrieve a bookmark with SQLGetData
or SQLGetStmtOption(SQL_GET_BOOKMARK).

To use bookmarks, they must be first enabled with the Statement Option
SQL_USE_BOOKMARKS.

*** Important note -- Currently, bookmarks can only be positioned to
when NOT using the Declare/Fetch option.  Another way of saying this is
when using Declare/Fetch, SQL_FETCH_NEXT is the only allowed option to
SQLExtendedFetch.   :-)

If anyone has any comments or questions, feedback is appreciated.

Byron