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

GetWhereExpression

It creates the where clause based on search settings of each field.

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 based on search settings of each field.

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 based on search settings of each field.

Parameters:
Description
includeTableNameThis indicates wheather the table name wil be prefixed to the column name.
sqlParamsThis array contains all the parameter objects .
paramPrefixThis value can be used to specify the prefix for parameter names will use.

Returns:
Type
System.String
 

GetWhereExpression(Boolean,ArrayList,String,Boolean)GetWhereExpression

It creates the where clause based on search settings of each field. This method overload can create expression for WHERE or HAVING clause.

Parameters:
Description
includeTableNameThis indicates wheather the table name wil be prefixed to the column name.
sqlParamsThis array contains all the parameter objects .
paramPrefixThis value can be used to specify the prefix for parameter names will use.
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