Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_DbConnectDatabase Access Wrapper

Public Function ReturnSingleRecAsDictionary (
sqlStr As String,
Optional DebugOn As Boolean = False,
Optional SuppressError As Boolean = False
) As xf_Dictionary

ProductID 2 ProductName Chang CategoryID 1

sqlStr as String

The SQL

Optional DebugOn as Boolean = False

Print the SQL statement before attempting to open the Recordset

Optional SuppressError as Boolean = False

Don't print any error message if an error is thrown, just return Null

Call Template:

Dim obj As New xf_Dictionary
Set obj = xf.DbConnect.ReturnSingleRecAsDictionary(sqlStr)
Set obj = xf.DbConnect.ReturnSingleRecAsDictionary(sqlStr, DebugOn, SuppressError)

See Also:

Example 1:

Dim TestDict as xf_Dictionary
Set TestDict = xf.DbConnect.ReturnSingleRecAsDictionary("SELECT ProductID, ProductName, CategoryID FROM Products WHERE ProductID=2")
Debug.Print TestDict.DictionaryDetailsAsString()

Key         Value
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd