Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_DbConnectxf_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:
1 2 | v = xf.DbConnect.ReturnRec("SELECT ProductName FROM Products WHERE ProductID=1")Chai |