Object Reference
-
Classes
-
xf_DataList
-
xf_DataListExt
-
xf_Dictionary
-
xf_PassArgsBase
-
xf_SingletonCache
-
xf_SQLCache
-
- Command Interface
- External
- General
- System Core
- System Library
xf_DataListExtDataListExt Base Class
Public Function AddSQLResultsetDbConn (
dbConn As xf_DbConnect,
sql As String,
Optional ListRowCountSQL As String = "",
Optional AppendToSet As Boolean = False,
Optional UseExtendedRSType As Boolean = False,
Optional AddFilterColumnName As String = ""
)
Calls AddSQLResultsetDbConn on the underlying DataList and then initialises the DataListExt.
DbConn
A DbConnect object to use (xf.DbConnect is the deafult XF DbConnect object which points to the current database)
Sql
The SQL query to use
dbConn as xf_DbConnect
(no description)
sql as String
(no description)
Optional ListRowCountSQL as String = ""
Run this SQL first to return a row count. This allows the number of rows to be allocated at the start and avoids progressing ReDim operations to expand the underlying storage array. Can increase loading speed for large datasets.
Optional AppendToSet as Boolean = False
(no description)
Optional UseExtendedRSType as Boolean = False
(no description)
Optional AddFilterColumnName as String = ""
(no description)
Call Template:
Dim obj As New xf_DataListExt
Dim v As Variant
v = obj.AddSQLResultsetDbConn(DbConn, Sql, dbConn, sql)
v = obj.AddSQLResultsetDbConn(DbConn, Sql, dbConn, sql, ListRowCountSQL, AppendToSet, UseExtendedRSType, AddFilterColumnName)
See Also:
Example 1:
lstExt.AddSQLResultsetDbConn xf.DbConnect, "SELECT * FROM Categories"