Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DbConnectxf_DbConnectDatabase Access Wrapper
Public Function OpenDAORecordset (
Source As String,
Optional RSType As RecordsetTypeEnum = -1,
Optional OpenRSOptions As RecordsetOptionEnum = -1,
Optional LockEdit As LockTypeEnum = -1,
Optional SuppressError As Boolean = False
) As DAO.Recordset
Opens a DAO Recordset object against the current database connection.
Source as String
The SQL or table or query name for which to open a result set
Optional RSType as RecordsetTypeEnum = -1
See the documentation for DAO.OpenRecordset
Optional OpenRSOptions as RecordsetOptionEnum = -1
See the documentation for DAO.OpenRecordset
Optional LockEdit as LockTypeEnum = -1
See the documentation for DAO.OpenRecordset
Optional SuppressError as Boolean = False
Suppress the error message if an error occurs
Call Template:
Dim obj As New DAO.Recordset
Set obj = xf.DbConnect.OpenDAORecordset(Source)
Set obj = xf.DbConnect.OpenDAORecordset(Source, RSType, OpenRSOptions, LockEdit, SuppressError)
See Also:
Example 1:
Dim recs as Dao.Recordset
Set recs = xf.DbConnect.OpenDAORecordset("SELECT * FROM Products WHERE CategoryID=2")