Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Scripterxf_ScripterSQL Script Generation and Processing
Public Function GetTableColList (
TableName As String,
dbs As DAO.Database,
Optional ExcludePK As Boolean = False,
Optional Delimiter As String = ", "
) As String
Return the table's column names as a comma separated list.
delimiter
The delimiter to use in constructing the delimited string
TableName as String
The table name
dbs as DAO.Database
The DAO database to which the table belongs
Optional ExcludePK as Boolean = False
Don't include PK column(s) in the lost
Optional Delimiter as String = ", "
(no description)
Call Template:
Dim s As String
s = xf.Scripter.GetTableColList(delimiter, TableName, dbs)
s = xf.Scripter.GetTableColList(delimiter, TableName, dbs, ExcludePK, Delimiter)
See Also:
Example 1:
colList = GetTableColList("tblProduct", dbs)