All methods

Public Function CacheSqlAsDataList(sqlStr As String, Optional dbConn As xf_DbConnect = Nothing, Optional UseExtendedRSType As Boolean = False, Optional AddFilterColumnName As String = "") As xf_DataList

Retrieve the SQL result set as a DataList, the first time from the database and subsequently from memory. The SQL statement is used as the key to identify the result set. Note that the return value is a pointer to a DataList, so if different code will be using the DataList result concurrently (eg. for iteration), a clone should be made before commencing any non-read operations.


Public Function ClearCache()

Clear all cached results

Public PrintDebugMessages As Boolean

Print messages to the Debug window indicating whether the result was cached or retrieved from the database