Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Visual Basic RDO Updates

2 posts in Windows NT Last posting was on 1998-02-11 14:43:09.0Z
USDA Posted on 1998-02-10 13:43:53.0Z
From: "USDA" <Daniel.Beseris@USDA.GOV>
Subject: Visual Basic RDO Updates
Organization: FSIS
Message-ID: <01bd3632$6bbdafa0$345c80c7@dbeseris.fsis.usda.gov>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 10 Feb 1998 08:43:53 -0500
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5215
Article PK: 1081294

I can not get any type of update operation to complete successfully using
RDO.
I always get the following message:
"This property or method is not supported when using the currently selected
cursor library."
My retrievals work fine. I have tried all the various cursor library
options in my connection and openresultset statements, such as
rdOpenKeyset,rduseODBC, etc.
My connection object has the "read only" option set to false.
I have tried the rdoQuery method, and the "rdoResultset.EDIT",
"rdoResultset.UPDATE" methods with no success.

I am accessing Sybase System 11 ver. 11.0.3. with Visual Basic 5.0
Enterprise edition. I have the latest ODBC drivers.

Dan Beseris
Daniel.Beseris@USDA.GOV


Kevin Campbell Posted on 1998-02-11 14:43:09.0Z
Message-ID: <34E1B8FD.8E0AC84A@gte.net>
Date: Wed, 11 Feb 1998 06:43:09 -0800
From: Kevin Campbell <KCampbel@gte.net>
Organization: Ad Rem, Inc.
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: USDA <Daniel.Beseris@USDA.GOV>
Subject: Re: Visual Basic RDO Updates
References: <01bd3632$6bbdafa0$345c80c7@dbeseris.fsis.usda.gov>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5212
Article PK: 1081291

Dan,

I can't shed much light on what you are trying, but I'll try. I use rdo
extensively but only ever as a conduit to the server, and as such all my
updates are performed by building an SQL statement to call a proc on the
server.

The ODBC driver supplied does not support all of the ODBC functions that
VB would like to use - notably it does not support the use of parameter
collections for executing procs.

From my days using Access :- have you ensured that the table you are
attempting an update to has a primary key defined? I suspect this is an
ODBC capability issue - perhaps you could try the following approach
instead:

MyServer.Execute("update MyTable set Col1 = 'MyValue' where ID=3")

where MyServer is an rdoConnection object.

Kevin Campbell
Ad Rem, Inc.
Sybase CAP