Object Reference
- Classes
- Command Interface
- External
- General
- System Core
- System Library
xf_DataList
xf_Interactxf_InteractInteraction
Public Function DbTableColumnExists (
TableName As String,
ColumnName As String,
Optional dbs As DAO.Database = Nothing
) As Boolean
Does the column of the table exist in the database ?
TableName as String
The name of the database table
ColumnName as String
The name of the table column
Optional dbs as DAO.Database = Nothing
Look in this database (default to the current database)
Call Template:
Dim b As Boolean
b = xf.Interact.DbTableColumnExists(TableName, ColumnName)
b = xf.Interact.DbTableColumnExists(TableName, ColumnName, dbs)
See Also:
Example 1:
DbTableColumnExists("tblClinicVisit", "VisitDate")