Received: from mail.rdc1.md.home.com (imail@ha1.rdc1.md.home.com [24.2.2.66])
	by hub.org (8.9.3/8.9.3) with ESMTP id XAA15553
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 23 Jul 1999 23:05:25 -0400 (EDT)
	(envelope-from byron.nikolaidis@home.com)
Received: from home.com ([24.4.141.52]) by mail.rdc1.md.home.com
	(InterMail v4.01.01.00 201-229-111) with ESMTP
	id <19990724030521.LFGG9894.mail.rdc1.md.home.com@home.com>;
	Fri, 23 Jul 1999 20:05:21 -0700
Message-ID: <37992BD0.13D46AC6@home.com>
Date: Fri, 23 Jul 1999 22:58:24 -0400
From: Byron Nikolaidis <byron.nikolaidis@home.com>
Organization: @Home Network
X-Mailer: Mozilla 4.5 [en]C-AtHome0405  (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
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
References: <3798711A.8AE49720@kearneydev.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



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