Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_SQLCachexf_SQLCacheCache SQL Result Sets
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.
DbConn
The DbConnect object, or if omitted use the default dbConnect (a DAO connection to the local database)
sqlStr as String
The SQL to retrieve from the database.
Optional dbConn as xf_DbConnect = Nothing
(no description)
Optional UseExtendedRSType as Boolean = False
(no description)
Optional AddFilterColumnName as String = ""
(no description)
Call Template:
Dim obj As New xf_SQLCache
Dim obj As New xf_DataList
Set obj = obj.CacheSqlAsDataList(DbConn, sqlStr)
Set obj = obj.CacheSqlAsDataList(DbConn, sqlStr, dbConn, UseExtendedRSType, AddFilterColumnName)
See Also:
Example 1:
Dim cache as New xf_SQLCache Dim lst as xf_DataList set lst = cache.CacheSqlAsDataList