Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_DataListDataList Base Class

Initialisation

Public Function AddSQLResultsetDbConn(dbConn As xf_DbConnect, sql As String, Optional ListRowCountSQL As String = "", Optional AppendToSet As Boolean = False, Optional ActivateColGroupFunctions As Boolean = False, Optional UseExtendedRSType As Boolean = False, Optional SuppressSqlError As Boolean = False, Optional AddFilterColumnName As String = "") As Variant

Read the result set of an SQL query from the database into the DataList. Use the result set column names to set up the column metadata.

Public Function CopyParamArray(FieldValList As Variant, Optional ColCount As Integer = 1, Optional PrintSymmetryError As Boolean = True) As Boolean

Use the passed list of values to initialise the DataList.
Passing the ColCount allows multiple rows of information to be set.
If PrintSymmetryError is True, then throw an error when an incomplete row of data is passed.

Public Sub SetupCols(ColCount As Integer, Optional WithColMetaData As Boolean = False)

Sets up the DataList columns. Since the DataList does not enforce column type, ony the number of columns needs to be specified.