[ASP Code]rs.open statement detailed description

Statement

'************************************************************************
' Rs.Open statement detailed description
' Rs. Open [first argument], [second parameter], [third parameter], [fourth parameter], (fifth parameter)
' Rs. Open [datasheet name or SQL Directive], [specify current connection], [instruct CursorType], [instruct LockType], (Adcmdtable/adcmdtext)
'-----------------------------------------------------------
' First parameter
' Can be a table name, or it can be an SQL statement
'-----------------------------------------------------------
' Second parameter
' Specifies the current connection.
'-----------------------------------------------------------
' Third parameter
' Instructs Cursortype,cursortype to indicate what cursor type will start the data.
' including adOpenForwardOnly, adOpenKeyset, adopendynamic and adOpenStatic,
' is divided into the following:
' third parameter constant numerical description
' adOpenForwardOnly 0 defaults to start a cursor that can only be moved forward (Forward only).
' adOpenKeyset 1 launches a keyset type of cursor.
' adOpenDynamic 2 launches a dynamic-type cursor.
' adOpenStatic 3 launches a static type of cursor.
'-------------------------------------------------------------
' Several of these cursor types will directly affect all properties and methods of the Recordset object, and the following list illustrates the differences between them.
' Recordset attribute adopenforwardonly (0) adOpenKeyset (1) adopendynamic (2) adopenstatic (3)
' AbsolutePage does not support read-write readable
' AbsolutePosition does not support read-write readable
' ActiveConnection can read, write, read, write, read and write
' BOF read-only read-only read-only
' Bookmark does not support read-write readable
' CacheSize can read, write, read, write, read and write
' CursorLocation can read, write, read, write, read and write
' CursorType can read, write, read, write, read and write
' EditMode read-only read-only read-only
' EOF read-only read-only read-only
' Filter can read, write, read-write, read-write, readable
' LockType can read, write, read, write, read and write
' MarshalOptions can read, write, read, write, read and write
' MaxRecords can read, write, read, write, read and write
' PageCount does not support read-only read-only
' PageSize can read, write, read, write, read and write
' RecordCount does not support read-only read-only
' Source can read, write, read-write, read-write, readable
' State read-only read-only read-only
' Status read-only read-only read-only
' AddNew support Support
' CancelBatch support Support
' CancelUpdate support Support
' Clone does not support unsupported
' Close support support ' support
' Delete support supporting support support
' GetRows support Support
' Move does not support support support
' MoveFirst support Support
' MoveLast support support support is not supported
' MoveNext support Support
' MovePrevious support support support is not supported
' Open support support supporting support
' Requery Support Support support support
' Resync does not support unsupported support support
' Supports support Support
' Update support support supporting support
' UpdateBatch support Support
' NextRecordset support Support
The ' NextRecordset method does not apply to Microsoft Access databases.

'------------------------------------------------------------------------
' Fourth parameter
' Instructs LockType to determine the type of lock (concurrency) that the provider should use when opening the Recordset.
' is divided into the following:
' Fourth parameter constants constant Value description
' adLockReadOnly 1 defaults, the Recordset object starts read-only and cannot run AddNew, Update, and Delete methods
' Adlockprssimistic 2 when the data source is being updated, the system temporarily locks the actions of other users to maintain data consistency.
' adLockOptimistic 3 When the data source is being updated, the system does not lock other users ' actions, other users can add, delete, and change the operation of the data.
' adLockBatchOptimistic 4 When the data source is being updated, other users must change the CursorLocation property to Adudeclientbatch to add, delete, and modify the data

'------------------------------------------------------------------------
' Fifth parameter
' is associated with the first parameter,
' If the first argument is a table name, then the fifth argument uses adCmdTable,
' If the first argument is an SQL statement, then the parameter is adCmdText
' Fifth parameter can be omitted without filling
'*******************************************************************

(Chnechen collected on the network and organized)

(Note: In this editor, display code formatting is not aligned, such as copy code in the DW Code View Code format will be aligned)