Skip to main content

Check if Field Exists

Function checkIfFieldExists(sFilename As String, sFieldname As String) As Boolean
	Dim db As database
	Dim table As table
	Dim field As field
	
	Set db = client.opendatabase(sFilename)
		Set table = db.TableDef
			On Error Resume Next
			Set field = table.GetField(sFieldname)
				If err.number = 0 Then
					checkIfFieldExists = False
					err.number = 0
				Else
					checkIfFieldExists = True
				End If
			Set field = Nothing
		Set table = Nothing
	Set db = Nothing
End Function