Re: Shaped Recordset and Updatebatch - VB6 & ADO & SQL Server 2000

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 00:07:09 -0400

Hi,

Do you get read-only recordset right after you call UpdateBatch or you do
some extra staff after this? Do you refresh recordset somehow or not? 

-- 
Val Mazur
Microsoft MVP
"Bass Pro" <Bass Pro@discussions.microsoft.com> wrote in message 
news:886665F3-7C0D-4953-A793-FEB61B102DCF@microsoft.com...
>I have a simple shaped recordset that is being updated.  The properties 
>are:
> locktype= optimisticbatch
> cursorlocation=client
> cursortype=static
>
> The problem is after the first update, which works fine, a second attempt 
> fails on the same record.   I checked and found the locktype had changed 
> to READ-ONLY.  What is causing it to change?
>
> I watched the events in SQL Profiler and all looked normal on the first 
> update.  There is no indication of errors.   Only the second invocation of 
> updatebatch fails and the recordset is not updated.
>
> Pls help,  Thanks.

Relevant Pages

  • Re: Accessing data from an MS Access database on a remote web serv
    ... Verify that you are not calling updatebatch without having the recordset ... connected to the database. ...
    (microsoft.public.inetserver.asp.db)
  • =?iso-8859-1?Q?Re:_Wann_UpdateBatch_ausf=FChren=3F=3F?=
    ... befindliche Recordset übernommen werden. ... dass die im lokalen Recordset vorhandenen Änderungen ... > ende braucht dann der updatebatch befehl sehr lange bis die daten ... CursorType und LockType des ADODB.Recordset mal genauer ...
    (microsoft.public.de.vb.datenbank)
  • Re: EditMode gets reset to adEditNone when adding multiple records
    ... the recordset contains UserGroups that are assigned to a ... When I examine the recordset right before UpdateBatch is called, ... resets the EditMode property to adEditNone, but the provider does not post ...
    (microsoft.public.data.ado)
  • Re: Shaped Recordset and Updatebatch - VB6 & ADO & SQL Server 2000
    ... "Val Mazur" wrote: ... > Do you get read-only recordset right after you call UpdateBatch or you do ... Do you refresh recordset somehow or not? ... >> updatebatch fails and the recordset is not updated. ...
    (microsoft.public.data.ado)
  • Update a read-only recordset
    ... Main form contains a subform (datasheet view) that is based on a ... read-only recordset. ... recordset that must be updated by the user. ... arbitrary number of records in the subform to be updated, ...
    (microsoft.public.access.forms)