From: Byron Nikolaidis <byronn@insightdist.com>
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!
Date: Fri, 08 Jan 1999 14:36:13 -0500
Message-ID: <36965E2D.12FEDD2C@insightdist.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, pgsql-interfaces@hub.org, pgsql-announce@postgreSQL.org
Subject: Re: NEW ODBC DRIVER v06-40-0004 supports Bookmarks!
In-Reply-To: <36965E2D.12FEDD2C@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox