RS.UpdateBatch & CancelBatch

Results 1 to 2 of 2

Thread: RS.UpdateBatch & CancelBatch

  1. #1
    Join Date
    Dec 1969

    Default RS.UpdateBatch & CancelBatch

    Can u help me in these doubts!!<BR>What is RS.updatebatch & RS.CancelBatch is used for ? How many records(Can i specify) will be updated ATONCE. what should be the Cursor type and lock type for using this ? Any other constraints else to be taken care of ?<BR>Is there any advantage for this method ?<BR><BR>Tom.

  2. #2
    Join Date
    Dec 1969

    Default RE: RS.UpdateBatch & CancelBatch

    I have used updatebatch to insert 32000 records (29 fields) at once. I don&#039t know what the limit is, but it&#039s obviously high. The cursortype has to be adopenstatic (the only type that&#039s supported in client side cursors) and the locktype is adlockbatchoptimistic. Remember to set your cursorlocation to aduseclient.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts