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 SQLUpdateSETClause1_VPA (
IntoTableName As String,
PrefixTableName As String,
DefaultInsertUnlisted As Boolean,
IncludeIdentity As Boolean,
CoerceNullToEmptyString As Boolean,
FieldValList As Variant
) As String

See the description for SQLUpdateSETClause1_MoreThan127Cols_VPA.
The same functionality except for
- cannot generate SET for more than 127 columns
- the ParamArray is passed in in code, not as a Variant

IntoTableName as String

The table name for the UPDATE statement

PrefixTableName as String

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

DefaultInsertUnlisted as Boolean

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

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 as a Variant

Call Template:

Dim s As String

s = xf.DefaultSchema.SQLConstructor.SQLUpdateSETClause1_VPA(IntoTableName, PrefixTableName, DefaultInsertUnlisted, IncludeIdentity, CoerceNullToEmptyString, FieldValList)