QuickObjects.ObjectBase Send comments on this topic.
GetWhereExpression Method
See Also 
Akal.QuickObjects.ObjectBase Namespace > ListField Class : GetWhereExpression Method

GetWhereExpression

It creates the where clause with a list of value seperated by the Seperator property value.

Parameters:
Description
includeTableNameThis indicates wheather the table name wil be prefixed to the column name.
sqlParamsThis array contains all the parameter objects .

Returns:
Type
System.String

Overload List

OverloadDescription
GetWhereExpression(Boolean,ArrayList)GetWhereExpression

It creates the where clause with a list of value seperated by the Seperator property value.

Parameters:
Description
includeTableNameThis indicates wheather the table name wil be prefixed to the column name.
sqlParamsThis array contains all the parameter objects .

Returns:
Type
System.String
 

GetWhereExpression(Boolean,ArrayList,String)GetWhereExpression

It creates the where clause with a list of value seperated by the Seperator property value.

Parameters:
Description
includeTableNameThis indicates wheather the table name wil be prefixed to the column name.
sqlParamsThis array contains all the parameter objects .
paramPrefixThis value is used as a prefix for the command parameter.

Returns:
Type
System.String
 

GetWhereExpression(Boolean,ArrayList,String,Boolean)GetWhereExpression

It creates the where clause with a list of value seperated by the Seperator property value.

Parameters:
Description
includeTableNameThis indicates wheather the table name wil be prefixed to the column name.
sqlParamsThis array contains all the parameter objects .
paramPrefixThis value is used as a prefix for the command parameter.
isHavingClauseThis value can be used to specify if the clause that is being built is HAVING clause or WHERE. If isHavingClause is set to true only the fields that do have an aggregate function applied will be included.

Returns:
Type
System.String
 

Requirements

Target Platforms: .NET Framework 1.1 or .NET Framework 2.0

See Also