A more detailed ASP Rs.Open statement detailing _asp Basics

'**************************************************************

'-------------------------------------------------------------
' First parameter
' Can be a table name, or it can be an SQL statement
'-------------------------------------------------------------chinaz^com
' 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.

Webmaster. Station


'-------------------------------------------------------------
' 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
Chinaz.com

' BOF read-only read-only read-only
' Bookmark does not support read-write readable
' CacheSize can read, write, read, write, read and write
Chinaz.com

' 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
Chinaz


' 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
Www_chinaz_com


' 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
Station. Long Station


' State read-only read-only read-only
' Status read-only read-only read-only
' AddNew support support support Webmaster. Station
' CancelBatch support Support
' CancelUpdate support Support
' Clone does not support unsupported
' Close support support ' support
Chinese Webmaster _ Station, for Chinese website to provide power

' Delete support supporting support support
' GetRows support Support
' Move does not support support support for China Station. Long Station
' MoveFirst support Support
' MoveLast support support support is not supported
' MoveNext support Support
China. Webmaster Station


' MovePrevious support support support is not supported
' Open support support supporting support
' Requery Support Support support support
Chinaz~com


' Resync does not support unsupported support support
' Supports support Support
' Update support support supported. National Webmaster Station
' UpdateBatch support Support
' NextRecordset support Support
The ' NextRecordset method does not apply to Microsoft Access databases. China. Webmaster Station


'--------------------------------------------------------------------
' 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. Www.Chinaz.com
' adLockBatchOptimistic 4 When the data source is being updated, other users must change the CursorLocation property to Adudeclientbatch in order to add, delete, and modify the data. National Webmaster Station

'-------------------------------------------------------------------
' 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
'*******************************************************************

China, station, long station

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