Object Reference
- Classes
- Command Interface
- External
- General
-
System Core
-
xf_Base
-
xf_BaseInstance
-
xf_BaseMin
-
xf_Globals
-
- System Library
xf_BaseInstanceXF Base Module
Public Function ReturnRec (
sql 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.
Sql
The SQL
sql as String
(no description)
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 = ReturnRec(Sql, sql)
v = ReturnRec(Sql, sql, DebugOn, SuppressError)
See Also:
Example 1:
v = ReturnRec("SELECT ProductName FROM Products WHERE ProductID=1")
Chai