Bean Software Search Control Documentation   
 
 

     




IfError Property


Description:

Represents behavior in case that Search Control can not build Where Clause. Search Control cannot build WHERE clause if:

  • Search expression is empty string or contains only NoiseWords.
  • If SearchColumns property not contains any column to search


Definition:

[Visual Basic .NET]

Public Property IfError() As enuIfError

[C#]

public enuIfError IfError() {get; set;}

Data type: enuIfError

Default value: enuIfError.TwoIsOne

Example: If value of Text property is empty string, then calling of getWhereClause() method will cause that control cannot build a valid SQL. If value of IfError property is set to enuIfError.EmptyString, then control will return empty string, so your SQL query will return all rows from your data set. If value of IfError property is set to enuIfError.TwoIsOne, then returned value will be " 2 = 1 ". It is impossible condition, so your SQL query will return zero rows from database.