Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_SchemaSQLConstructorSQL Constructor

Public Function SQLUpdateSETClause (
IntoTableName As String,
PrefixTableName As String,
DefaultInsertUnlisted As Boolean,
IncludeIdentity As Boolean,
CoerceNullToEmptyString As Boolean,
ParamArray 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

ParamArray FieldValList() as Variant

The paired column names and values

Call Template:

Dim s As String
s = xf.DefaultSchema.SQLConstructor.SQLUpdateSETClause(IntoTableName, PrefixTableName, DefaultInsertUnlisted, IncludeIdentity, CoerceNullToEmptyString, FieldValList)

See Also:

Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd