Re: Stale Data

From: Val Mazur (group51a_at_hotmail.com)
Date: 03/18/04 

Date: Wed, 17 Mar 2004 21:43:47 -0500

Hi,

Do you re-connect your recordset to the database before calling UpdateBatch?
Could you post your code here? 

-- 
Val Mazur
Microsoft MVP
"JS" <js@somewhere.com> wrote in message 
news:%238$AXYyCEHA.3280@TK2MSFTNGP09.phx.gbl...
>i have a disconnected rs and display the in grid
> when user delete the stale data when i called
> updatebatch it doesn't raise an error.
>
> thus how i can make sure that i try to delete the stale data
> because base on current cache of data i will update other
> records in related table
>
> btw, i am using ms access as its database.
>
>

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)
  • Re: Update table fields from XML file
    ... > 2- Save my recordset to XML File ... > 5- Execute a updatebatch method to affect change to database. ... In between the time it's persisted and the time UpdateBatch is called, ...
    (microsoft.public.vb.database.ado)
  • UpdateBatch or Update w/Stored Procedure (Database via Wireless Network)
    ... Server 2000 database. ... across the wireless network while the stored procedure is executed. ... performance hit at the closing of a form by doing UpdateBatch via ADO, ...
    (microsoft.public.vb.database.ado)
  • =?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: Stale Data
    ... > the problem is if i change the stale data and call updatebatch, ... > conn.CursorLocation = adUseClient ... > m_rs.Open strSQL, conn, adOpenKeyset, adLockBatchOptimistic, adCmdText ...
    (microsoft.public.data.ado)