Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Scripterxf_ScripterSQL Script Generation and Processing
Public Function GetTablePrimaryKeyColNameList (
TableName As String,
dbs As DAO.Database ,
Optional Delimiter As String = ", ",
Optional AddAutonumAsterisk As Boolean = False
) As String
Return the column name(s) in the primary key 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 Delimiter as String = ", "
(no description)
Optional AddAutonumAsterisk as Boolean = False
Add an asterisk at the right of the autonumber column's name
Call Template:
Dim s As String
s = xf.Scripter.GetTablePrimaryKeyColNameList(delimiter, TableName, dbs)
s = xf.Scripter.GetTablePrimaryKeyColNameList(delimiter, TableName, dbs, Delimiter, AddAutonumAsterisk)
See Also:
Example 1:
colList = GetTablePrimaryKeyColNameList("tblProduct", dbs)