Logo
Home Cart [Log In] About Us Contact Us

Object Reference

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:

1
2
v = 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