RS.Open SQL, CONN, A, Ba: adopenforwardonly (= 0) read-only, and current data records can only move down, you will not be able to use rs.movelast | rs.moveprevious 1, 2, 3 Other B: B: AdlockReadOnly (= 1) default lock type, record set is read-only, can not modify the record you will not use rs.update 2, 3, 4 You can also have you have a relationship with B, will b Set new data in addition to 1
Rs.Update after operation, the cursor is in the last one
Rs.Updaters.movefirst cursor in the first RS.UPDATERS.MOVENEXT cursor in the second RS.UPDATERS.MOVEPREVIOUS Cursor in the countdown, only read only RS.Open SQL, CONN, 0, 1 can only move downward Supports RS.Move (NUM), does not support RS.RecordCountrs.open SQL, CONN, 1, 1 free movement, support RS.RecordCount common reading and writing to open (insert new data or update) RS.Open SQL, CONN, 0 , 3rs.open SQL, CONN, 1, 3