Generate SQL from passed in values

Public Function MakeUpdateOrInsertFromVals(TableName As String, InsertNewRec As Boolean, WhereClause As String, ParamArray FieldValList() As Variant) As String

Create an update or insert statement from the passed in values, validating and formatting each value according to the column type. For INSERT statements validation also includes checking table columns that have not been specified in the passed list, to ensure they are either nullable or have a default value.


Public Function MakeWhereFromVals(TableName As String, UseTablePrefix As String, ParamArray FieldValList() As Variant) As String

Create an SQL WHERE clause (without the WHERE keyword) from the passed in values, validating and formatting each value according to the column type.


Public Function MakeWhereFromVals_VPA(TableName As String, UseTablePrefix As String, FieldValList As Variant) As String

Create an SQL WHERE clause (without the WHERE keyword) from the passed in values, validating and formatting each value according to the column type.
The _VPA suffix indicates that the ParamArray is passed in as a Variant.