NEW ODBC DRIVER v06-40-0004 supports Bookmarks!
От | Byron Nikolaidis |
---|---|
Тема | NEW ODBC DRIVER v06-40-0004 supports Bookmarks! |
Дата | |
Msg-id | 36965E2D.12FEDD2C@insightdist.com обсуждение исходный текст |
Список | pgsql-interfaces |
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
В списке pgsql-interfaces по дате отправления: