From: Byron Nikolaidis <byronn@insightdist.com>
To: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Cc: Oliver Stegle <ostegle@fr.infra.net>
Cc: bcurnow@sonnet.com <bcurnow@sonnet.com>
Subject: Got the Cursor Library to work! YE HA!
Date: Wed, 27 May 1998 15:33:51 -0400
Message-ID: <356C6A9F.8D797AEA@insightdist.com> (raw)
Hi,
I finally got the odbc cursor library to work with our odbc driver!
This means that things like MFC's CRecordSet snapshot, and others
hopefully Visual Basic, etc, will work and also you can do positioned
updates! I successfully scrolled around and updated a CRecordset!
The cursor library has always existed (we redistribute it with the
driver), and in fact for MFC at least, the default was to try to load
it. However, because of shortcomings in the driver, the cursor library
always failed to load, thus recordsets were not updatable. Most notably
preventing the cursor library from working was the missing
SQLGetCursorName and SQLSetCursorName functions, which I added, as well
as several incorrect info calls.
Now, you can execute positioned sql ( select for update, update ...
where current of, etc.), and use SQLSetPos(), just by loading the
library.
Here is a list of things the library adds to the driver:
----------------------------------------------------
SQLExtendedFetch (complete, with FETCH_RELATIVE as well)
Postioned SQL Statements (select for update, update ... where current of
<cursor>)
Positioned Operations (with SQLSetPos)
Block cursors (multiple rows of bound data)
Scrollable cursors (static)
This is great because it elevates our level 1 driver to alot more
functionality, like that of level 2 drivers!
I will be posting the new driver at our website, probably friday.
If you need more information about any of this stuff, dont hesitate to
ask me.
Regards,
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, ostegle@fr.infra.net, bcurnow@sonnet.com
Subject: Re: Got the Cursor Library to work! YE HA!
In-Reply-To: <356C6A9F.8D797AEA@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