資料控制項(xiàng)與資料存取物件-資料下載頁(yè)
2025-07-21 12:55本頁(yè)面
【正文】 e recordset is open aren’t visible ? All types of movement ? Forwardonly: adOpenForwardOnly (default) ? Static nonupdateable recordset ? Only Scroll forward through the records (MoveNext, GetRows) Actions: Insert, Update amp。 Delete 使用 Cursortype =“書(shū)籍” =Cn =AdOpenDynamic 或 “書(shū)籍” ,Cn, AdOpenDynamic LockType 標(biāo)示如何鎖定資料表 種類(lèi) 值 說(shuō)明 AdOpenReadOnly 1 唯讀 AdOpenPessimistic 2 悲觀鎖定 ,取得資料表後鎖定 AdOpenOptimistic 3 樂(lè)觀鎖定 ,更新時(shí)才鎖定 AdOpenBatchOptimistic 4 批次樂(lè)觀鎖定 ,需下 UPDATE Batch LockType ? adLockReadOnly ? Cannot alter the data ( no updates, inserts, or deletions ) ? adLockPessimistic ( better at the database’s integrity ) ? Record lock during editing ? Lock out everyone else from the record you’re editing ? Lock from the time of first change until call the Update method ? adLockOptimistic ? No lock during editing ? Lock the record only during the call to Update ? adLockBatchOptimistic ? No lock during editing ( modify, insert, delete ) ? Batch update: Lock the records only during the call to UpdateBatch 使用 LockType =“書(shū)籍” =Cn =AdOpenDynamic = AdOpenPessimistic 或 “書(shū)籍” ,Cn, AdOpenDynamic, AdOpenPessimistic
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1