Updating recordset with array

Results 1 to 2 of 2

Thread: Updating recordset with array

  1. #1
    Join Date
    Dec 1969

    Default Updating recordset with array

    My recordset objRS has several rows which need to be updated with the data in the arrays arrCategory and arrStatus. The number of rows in the recordset match the number of rows in the array. Is there anything obviously wrong with the following code as the updates it produces are sometimes, but not always incorrect. In particular the updates start going wrong when data in 2 or more of the rows in the array are the same.<BR><BR>&#060;%<BR>For i = 0 to ubound(arrCategory,1)<BR> objRS("CATEGORYID") = arrCategory(i)<BR> objRS("STATUSID") = arrStatus(i)<BR> objRS.Update<BR> objRS.MoveNext<BR>Next<BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default Objrs.Addnew ?????


Posting Permissions

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