p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: UpdateBatch


Message #1 by alakale@y... on Sun, 3 Sep 2000 03:12:13 +0100
Using MoveNext implicitly calls Update, so AFAIK, the UpdateBatch is not 
necessary.

Imar


At 03:12 AM 9/3/2000 +0100, you wrote:
>Whats wrong with this code:
>--------------------------------------------------------------------------

>objRS.Open "MyTable", strConnect, adOpenStatic, adLockBatchOptimistic,
>adCmdTable
>i = 1
>While NOT objRS.EOF
>         objRS("name")= "name" & i
>         objRS("sname")= "surname" & i
>         i = i + 1
>         objRS.MoveNext
>Wend
>      objRS.UpdateBatch
>--------------------------------------------------------------------------
>some suggest that i should do  objRS.UpdateBatch inside the loop, but the
>purpose of UpdateBatch is "Do it all in one", so why should I? And why
>does it gimme appending error? Thanks! (i didnt write the whole code,
>there no other errors :)
>
>---
>You are currently subscribed to proasp_codeclinic.
>$subst('Email.Unsub')



  Return to Index