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

From: Bass Pro (BassPro_at_discussions.microsoft.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 11:55:03 -0700

Hi Val,
I found the problem. It turned out to be that I have a timestamp field. When I save with the updatebatch using a disconnected shaped recordset, it doesn't update on the second attempt of an update on the same record. I removed the timestamp field and the problem goes away. I'm still lost as to why it doesn't work. I couldn't find anything in any manual indicating that was a problem.

I'm using ADO 2.8. 

-- 
Bill Jones
"Val Mazur" wrote:
> 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