Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_DbConnectDatabase Access Wrapper

Public Function ReturnRec (
sqlStr As String,
Optional DebugOn As Boolean = False,
Optional SuppressError As Boolean = False
) As Variant

Returns the value from the first column and row of the result set from the passed SQL. Like DLookup, but takes a full SQL statement.

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 v As Variant
v = xf.DbConnect.ReturnRec(sqlStr)
v = xf.DbConnect.ReturnRec(sqlStr, DebugOn, SuppressError)

See Also:

Example 1:

v = xf.DbConnect.ReturnRec("SELECT ProductName FROM Products WHERE ProductID=1")
Chai
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd