Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_SchemaSQLConstructorSQL Constructor

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

IntoTableName as String

The table name for the INSERT statement

TemplateTableName as String

The table name used to retrieve the schema used for column generation and validation (may be for a different table to IntoTableName but should be similar at least)

DefInsTable as String

The table name to append to a column name in the SELECT value list

SQLFromSource as String

The FROM part of the SELECT statement.

DefaultInsertUnlisted as Boolean

Automatically generate column insertions for columns not defined in the passed name/value list

AllowAddlCols as Boolean

Allow column names in the passed name/value list that are not in the table schema

IncludeIdentity as Boolean

Generate column insertions for the identity column (otherwise it is omitted)

CoerceNullToEmptyString as Boolean

Automatically add nz() around inserted column names

ParamArray FieldValList() as Variant

The paired column names and values

Call Template:

Dim s As String

s = xf.DefaultSchema.SQLConstructor.SQLInsertFromSQL1(IntoTableName, TemplateTableName, DefInsTable, SQLFromSource, DefaultInsertUnlisted, AllowAddlCols, IncludeIdentity, CoerceNullToEmptyString, FieldValList)