Home Cart [Log In] About Us Contact Us

Object Reference

xf_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")
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd