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

See the description for SQLUpdateSETClause1_MoreThan127Cols_VPA.
The same functionality except for
- SplitResultString is not present
- 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

SecondResultString as String

The second SET clause (if more than 127 columns), otherwise empty

ParamArray FieldValList() as Variant

The paired column names and values

Call Template:

Dim s As String

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