Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Recordset Documentation and short description.


Message #1 by "Leonid" <vleonid@m...> on Mon, 10 Feb 2003 16:34:09
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.

  Return to Index