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 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)

IntoTableName as String

The table name for the INSERT statement

objTableSchema as xf_DbSchema_Table

The table schema to use 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

FieldValList as Variant

The paired column names and values ParamArray, passed as a Variant

Call Template:

Dim s As String

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