Generate SQL Inserts

Generate SQL to insert from an existing table, allowing column override with manual values.

Public Function SQLInsertFromSQL(IntoTableName As String, SQLFromSource As String, DefaultInsertUnlisted As Boolean, AllowAddlCols As Boolean, IncludeIdentity As Boolean, CoerceNullToEmptyString As Boolean, ParamArray FieldValList() As Variant) As String

See the description for SQLInsertFromSQL_VPA.
The same functionality except for
- the schema must be for the same table as that being inserted to
- DefInsTable is not a parameter
- the ParamArray is passed in in code, not as a Variant

Public Function SQLInsertFromSQL_VPA(IntoTableName As String, objTableSchema As xf_DbSchema_Table, DefInsTable As String, SQLFromSource As String, DefaultInsertUnlisted As Boolean, AllowAddlCols As Boolean, IncludeIdentity As Boolean, CoerceNullToEmptyString As Boolean, FieldValList As Variant) As String

Generates (if error had not been flagged) : INSERT INTO tblDest (AddlCol1,PK,Dest2, Dest3) SELECT 21,PKCopy,SomeCol2, SomeCol3 FROM (any SQL statement)

Public Function SQLInsertFromSQL1(IntoTableName As String, TemplateTableName As String, DefInsTable As String, SQLFromSource As String, DefaultInsertUnlisted As Boolean, AllowAddlCols As Boolean, IncludeIdentity As Boolean, CoerceNullToEmptyString As Boolean, ParamArray FieldValList() As Variant) As String

See the description for SQLInsertFromSQL_VPA.
The same functionality except for
- TemplateTableName is used to retrieve objTableSchema
- the ParamArray is passed in in code, not as a Variant

Public Function SQLInsertFromSQL2(IntoTableName As String, objTableSchema As xf_DbSchema_Table, DefInsTable As String, SQLFromSource As String, DefaultInsertUnlisted As Boolean, AllowAddlCols As Boolean, IncludeIdentity As Boolean, CoerceNullToEmptyString As Boolean, ParamArray FieldValList() As Variant) As String

See the description for SQLInsertFromSQL_VPA.
The same functionality except for
- the ParamArray is passed in in code, not as a Variant