Default constructor for BaseField class.  

_operator

_operator has been marked as protected just to allow the inheriting classes the ability to change the operator without going through the property set method, which will reset the UseInSearch flag.

		this._operator = " IN ";
		

		this._operator = " = ";
		

Holds a Boolean value that can be used for specifying weather this field can be used in grouped result set or not.

Holds a Boolean value that can be used for specifying weather this field can contain Null values.  

Holds a Boolean value that can be used for specifying weather this field can be used in updates/inserts or not.

This value doesn't necessarily indicate that the field will be used in the updates/inserts, but if this is true, only then the field's UseInSave property will be used.

This can be useful to the User Interface controls to be able to decide if this field will allow updates or not.  

Holds a Boolean value that can be used for specifying weather this field can be used in searching resultset or not.

This value doesn't necessarily indicate that the field will be used in the Search criteria, but if this is true, only then the field's UseInSearch property will be used.

This can be useful to the User Interface controls to be able to decide if this field will allow search or not.  

Holds a Boolean value that can be used for specifying weather this field can contain Null values.

This value doesn't necessarily indicate that the field will be used in the sort, but if this is true, only then the field's Sort property will be used.

This can be useful to the User Interface controls to be able to decide if this field will allow sorting or not.  

Holds a reference to the business object that contains this field.  

Returns a Type representation of the .NET type that is equivalent to the underlying database type.  

GroupPosition can be used to specify the position of the column in the group by clause.  

Determines weather a field will be used in group by clause and the aggregate function to use (if any).  

IsCustom

Holds a Boolean value that can be used for specifying weather this field's name is a custom name or not.

If it is set to true the Name property can be assigned any valid sql String. This can be very useful for creating calculated columns in result sets where the calculated column is created by the database server.

	MyField.IsCustom = true;
	

Holds a Boolean value that can be used for checking if the value of this field has been modified since the business object values were loaded last.  

Holds a Boolean value that can be used for specifying weather this field's current value is Null or not.

When IsNull is set to True the Value is destroyed.  

List can be used to specify a list of values that are to be used in the search criteria.

This is only used if the SearchMode is set to List or All.  

Holds this field's actual column name from the database.  

Operator

Holds a String value that can be used for specifying search operator. Changing the Operator value also set ths UseInSearch property to true. NOTE: Starting version 3.x you can use Operators class that provides constants for each operator that is implemented.

	MyField.Operator = Operators.EqualTo;
	

	MyField.Operator = Operators.NotEqualTo;
	

	MyField.Operator = Operators.Like;
	

Holds a String value that can be used for specifying the result set name (i.e. an alias) for this column.

SearchCondition

Holds a String value that can be used for specifying search condition.

You can use MoreResults property of the business object and that will automatically assign a value to the SearchCondition property. However, by directly changing the value of this property you gain full control over the search critiria.

	MyField.SearchCondition = " AND ";
	

	MyField.SearchCondition = " OR ";
	

SearchMode is used to determine weather the field's where clause will be based on the value, list or all.  

SearchPostfix

Holds a String value that can be used as postfix to the search criteria for this field.

	MyField.SearchPostfix = " ) ";
	

SearchPrefix

Holds a String value that can be used as prefix to the search criteria for this field.

	MyField.SearchPrefix = " (  ";
	

Determines weather a field will be used in sort and its sort direction.  

SortPosition can be used to specify the position of the column in the sort order.  

Holds a IDataParameter value that can be used for specifying the SqlParameter Name.

SqlParam is not serialized and it is also ignored by the xml serialization.

In normal circumstances, there is no need to assign value to this property as it automatically handles it.  

Holds a String value that can be used for specifying the table name for this field.  

Holds a String value that can be used for specifying the table's result set name for this field.

This should match with the value of the business objects ResultSetName property.

In normal circumstances, there is no need to assign value to this property as it automatically handles it.  

Holds a Boolean value that can be used for specifying weather to include this field in specifying the update command.  

Holds a Boolean value that can be used for specifying weather to include this field in specifying the search criteria.  

Place holder object for the Value, this should be overridden by each inheriting field.  

Holds a Boolean value that can be used for specifying weather to include this field in resulting dataset or not.  

It assigns currently stored values to database parameter object in SqlParam.

Parameters:

Description
queryType

 

It returns the System.Type with this field type.

Returns:

Type
System.Type

 

It returns the value assignment String for this field to be used in an insert statement.

Parameters:

Description
sqlParams	This array contains all the parameter objects .

Returns:

Type
System.String

 

It creates the where clause for the List field of each field.

Parameters:

Description
includeTableName	This indicates wheather the table name wil be prefixed to the column name.
sqlParams	This array contains all the parameter objects .

Returns:

Type
System.String

 

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

Parameters:

Description
includeTableName	This indicates wheather the table name wil be prefixed to the column name.
sqlParams	This array contains all the parameter objects .

Returns:

Type
System.String

 

GetResultSetName compares the Name property with ResultSetName property and returns ResultSetName if it is different from Name property.

Returns:

Type
System.String

 

It returns a String if the Sort is set to either Ascending or Descending SortTypes value. If Sort is set to None then a blank value is returned.

Returns:

Type
System.String

 

It returns a value that represents a parameter name appropriate for the selected database type. In normal situations it is needed to call this method as all the parameter handeling is done by business objects.

Parameters:

Description
includeTableName	This indicates wheather the table name wil be prefixed to the column name.
prefix	Value will be prefixed with the parameter name.
count	Used to ensure that all parameter names are unique.

Returns:

Type
System.String

 

It returns a value that represents a parameter name appropriate for the selected database type. In normal situations it is needed to call this method as all the parameter handeling is done by business objects.

Parameters:

Description
includeTableName	This indicates wheather the table name wil be prefixed to the column name..

Returns:

Type
System.String

 

It returns the value assignment String for this field.

Parameters:

Description
sqlParams	This array contains all the parameter objects .

Returns:

Type
System.String

 

GetValueExpression does not provide any functionality but unctionality is provided by each type of field class as each field class overwrites this function.

Returns:

Type
System.String

 

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

Parameters:

Description
includeTableName	This indicates wheather the table name wil be prefixed to the column name.
sqlParams	This array contains all the parameter objects .

Returns:

Type
System.String

 

It doesnot provide any functionality at this level. It is implemented by each field type.

Parameters:

Description
strValue

 

It is implemented by each field type class.

Parameters:

Description
param