access_asp thread: Recordset Documentation and short description.
I hope this will help to many new programmers.
Syntax:
*******************************************************
objRecordset.Open source,actconn,cursortyp,locktyp,opt
*******************************************************
Parameter Description:
----------------------------
source: Optional. Specifies a data source.
The source parameter may be one of the following:
1) URL
2) relative/full file path name
3) Command object
4) SQL statement
5) stored procedure
6)table name
actconn: Optional.
1) connection string or a Connection object
cursortyp: Optional.
1) CursorTypeEnum value
that specifies the type of cursor to use
when opening a Recordset object.
Default is adOpenForwardOnly
locktyp: Optional.
1) LockTypeEnum value
that specifies the type of locking on
a Recordset object.
Default is adLockReadOnly
opt: Optional.
1) Specifies how to evaluate
the source parameter if it is not a Command object.
Can be one or more
CommandTypeEnum or ExecuteOptionEnum values.
----------------------------------------------------------------------
CursorTypeEnum Values
----------------------------
adOpenUnspecified : -1
adOpenForwardOnly : 0
adOpenKeyset : 1
adOpenDynamic : 2
adOpenStatic : 3
LockTypeEnum Values
-----------------------------
adLockUnspecified : -1
adLockReadOnly : 1
adLockPessimistic : 2
adLockOptimistic : 3
adLockBatchOptimistic : 4
CommandTypeEnum Values
------------------------------
adCmdUnspecified : -1
adCmdText : 1
adCmdTable : 2
adCmdStoredProc : 4
adCmdUnknown : 8
adCmdFile : 256
adCmdTableDirect : 512
ExecuteOptionEnum Values
-----------------------------
adOptionUnspecified : -1
adAsyncExecute : 16
adAsyncFetch : 32
adAsyncFetchNonBlocking:64
adExecuteNoRecords : 128
adExecuteStream : 256
adExecuteRecord : 512
Leonid.