Detailed description of ASP Rs. Open statements

Source: Internet
Author: User
Tags unsupported

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

'-------------------------------------------------------------
'First Parameter
'It Can Be A table name or an SQL statement
'--------------------------------------------------------------- Chinaz ^ com
'Second Parameter
'Specifies the current connection.
'-------------------------------------------------------------
'Third Parameter
'Indicates cursortype. cursortype indicates the type of cursor to start data,
'Includes adopenforwardonly, adopenkeyset, adopendynamic, and adopenstatic,
'Statement:
'Third parameter constant value description
'Adopenforwardonly 0 defaults to start a forward-only cursor ).
'Adopenkeyset 1 start a keyset type cursor.
'Adopendynamic 2 starts a dynamic type cursor.
'Adopenstatic 3 Start a static type cursor.

Webmaster. Station

'-------------------------------------------------------------
'The previous cursor types directly affect all the attributes and methods of the recordset object. The following lists the differences between them.
'Recordset attributes adopenforwardonly (0) adopenkeyset (1) adopendynamic (2) adopenstatic (3)
'Absolutepage does not support read/write.
'Absoluteposition does not support read/write.
'Activeconnection can be read/written or read/write
Chinaz.com

'Bof read-only
'Bookmark does not support read/write but does not support read/write.
'Cachesize: readable/writable
Chinaz.com

'Cursorlocation can be read/written or read/write
'Cursortype can be read/written or read/write
'Editmode read-only
'Eof read-only
Chinaz

'Filter can be read/written or read/write
'Locktype can be read/written or read/write
'Externaloptions can be read/written or read/write
'Maxrecords can be read/written or read/write
Www_chinaz_com

'Pagecount does not support read-only and read-only
'Pagesize: readable/writable
'Recordcount does not support read-only and read-only
'Source: readable/writable
Station. Long SITE

'State read-only
'Status read-only
'Addnew' supports support for webmasters.
'Support for cancelbatch
'Support for cancelupdate
'Clone unsupported
'Close' support
Chinese webmaster _ station, providing motivation for Chinese Websites

'Delete supported
'Getrows support
'Move does not support Chinese site. Long SITE
'Movefirst support
'Movelast unsupported
'Support for movenext
China webmaster site

'Moveprevious unsupported
'Open Support
'Requery support supported
Chinaz ~ Com

'Resync unsupported
'Support for ororts
'Update Support supports Chinese webmasters
'Updatebatch support supported
'Nextrecordset supported
The 'nextrecordset method is not applicable to Microsoft Access databases. China webmaster site

'--------------------------------------------------------------------
'Fourth Parameter
'Indicates locktype to determine the type of lock (concurrency) to be used when the provider opens the recordset.
'Statement:
'The fourth constant value of the parameter constant
'Adlockreadonly 1 default value. The recordset object is started in read-only mode and cannot run addnew, update, delete, and other 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 modify data. Www.chinaz.com
'Adlockbatchoptimistic 4 when the data source is being updated, other users must change the cursorlocation attribute to adudeclientbatch to add, delete, and modify the data.

'-------------------------------------------------------------------
'Fifth Parameter
'Related to the first parameter,
'If the first parameter is the table name, the fifth parameter uses adcmdtable,
'If the first parameter is an SQL statement, this parameter is adshorttext
'Leave the fifth parameter unspecified.
'*************************************** ****************************

China site. Long SITE

(Note: displayed in this editorCodeIncorrect format. For example, if the copy code is in the DW Code view, the code format can be aligned)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.