Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_SchemaSQLConstructorSQL Constructor

Public Function MakeWhereFromVals (
TableName As String,
UseTablePrefix As String,
ParamArray FieldValList() As Variant
) As String

Create an SQL WHERE clause (without the WHERE keyword) from the passed in values, validating and formatting each value according to the column type.

TableName as String

The table name

UseTablePrefix as String

Add this table prefix to the column names, eg. [Table3].[Column1]

ParamArray FieldValList() as Variant

The paired column names and values

Call Template:

Dim s As String
s = xf.DefaultSchema.SQLConstructor.MakeWhereFromVals(TableName, UseTablePrefix, FieldValList)

See Also:

Example 1:

sql = objSchema.SQLConstructor.MakeWhereFromVals "Product", "", _
"ProductID", 23
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd