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 


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

>objRS.Open "MyTable", strConnect, adOpenStatic, adLockBatchOptimistic,
>i = 1
>While NOT objRS.EOF
>         objRS("name")= "name" & i
>         objRS("sname")= "surname" & i
>         i = i + 1
>         objRS.MoveNext
>      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.

  Return to Index