From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: secret <secret@kearneydev.com>
Cc: 'pgsql-interfaces@postgreSQL.org' <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] S1C00: Only SQL_POSITION/REFRESH is supported for SQLSetPos
Date: Fri, 23 Jul 1999 22:58:24 -0400
Message-ID: <37992BD0.13D46AC6@home.com> (raw)
References: <3798711A.8AE49720@kearneydev.com>
secret wrote:
>
> I've just started getting this ODBC error under Windows 95/NT when
> trying to modify a record... This is in Visual Basic 5.0. I haven't had
> problems before, and didn't change anything to get this.(I noticed it
> when I upgraded 6.5.1, but then downgraded to 6.4.2 thinking that might
> be the reason)
>
> --David
Your application (VB) is trying to use the odbc function SQLSetPos() to
either Update, Delete, or Add a row to a rowset. Unfortunately, the
driver does not support this advanced feature.
There should be a connect option in vb that deals with how to use the
cursor library. The cursor library should be capable of translating a
positioned update into a standard one for drivers that don't support
that.
Also, you probably want to turn off the declare/fetch option.
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: byron.nikolaidis@home.com, secret@kearneydev.com
Subject: Re: [INTERFACES] S1C00: Only SQL_POSITION/REFRESH is supported for SQLSetPos
In-Reply-To: <37992BD0.13D46AC6@home.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