WhereBuilderMethods

Overview

Location

Instance Methods


constructor

Creates a new instance of the WhereBuilderMethods class.

 

constructor(global: GlobalObject)

 

WhereBuilderMethods(GlobalObject global)

 

Sub New (global As GlobalObject)

Parameters:

  • global:

createBetween

 

method createBetween(expression: WhereBuilderWrapper; lower: WhereBuilderWrapper; upper: WhereBuilderWrapper): WhereBuilderWrapper

 

WhereBuilderWrapper createBetween(WhereBuilderWrapper expression, WhereBuilderWrapper lower, WhereBuilderWrapper upper)

 

Function createBetween(expression As WhereBuilderWrapper, lower As WhereBuilderWrapper, upper As WhereBuilderWrapper) As WhereBuilderWrapper

Parameters:

  • expression:
  • lower:
  • upper:

createBinary

Creates a WhereBinary Object (Business Rules Scripting); use this to create a where binary expression, like field = 15.

Possible values of the aOperator parameter are: * And * Or * Xor * Less * LessOrEqual * Greater * GreaterOrEqual * NotEqual * Equal * Like * In * Addition * Subtraction * Multiply * Divide

 

method createBinary(left: Object; right: Object; operator: String): WhereBuilderWrapper

 

WhereBuilderWrapper createBinary(Object left, Object right, String operator)

 

Function createBinary(left As Object, right As Object, operator As String) As WhereBuilderWrapper

Parameters:

  • left:
  • right:
  • operator:

createConstant (Object): WhereBuilderWrapper

Creates a WhereConstant Object (Business Rules Scripting).

 

method createConstant(value: Object): WhereBuilderWrapper

 

WhereBuilderWrapper createConstant(Object value)

 

Function createConstant(value As Object) As WhereBuilderWrapper

Parameters:

  • value:

createConstant (Object, String): WhereBuilderWrapper

Creates a WhereConstant Object (Business Rules Scripting) of required type.

 

method createConstant(value: Object; type: String): WhereBuilderWrapper

 

WhereBuilderWrapper createConstant(Object value, String type)

 

Function createConstant(value As Object, type As String) As WhereBuilderWrapper

Parameters:

  • value:
  • type:

createField (String): WhereBuilderWrapper

Creates a WhereField Object (Business Rules Scripting). This is a reference to a data table field.

 

method createField(field: String): WhereBuilderWrapper

 

WhereBuilderWrapper createField(String field)

 

Function createField(field As String) As WhereBuilderWrapper

Parameters:

  • field:

createField (String, String): WhereBuilderWrapper

Creates a WhereField Object (Business Rules Scripting). This is a reference to a field in the table in the "aTable" parameter.

 

method createField(table: String; field: String): WhereBuilderWrapper

 

WhereBuilderWrapper createField(String table, String field)

 

Function createField(table As String, field As String) As WhereBuilderWrapper

Parameters:

  • table:
  • field:

createList

 

method createList(params items: array of WhereBuilderWrapper): WhereBuilderWrapper

 

WhereBuilderWrapper createList(params WhereBuilderWrapper[] items)

 

Function createList(ParamArray items As array of WhereBuilderWrapper) As WhereBuilderWrapper

Parameters:

  • items:

createMacro

 

method createMacro(name: String; params values: array of WhereBuilderWrapper): WhereBuilderWrapper

 

WhereBuilderWrapper createMacro(String name, params WhereBuilderWrapper[] values)

 

Function createMacro(name As String, ParamArray values As array of WhereBuilderWrapper) As WhereBuilderWrapper

Parameters:

  • name:
  • values:

createNull

Creates a WhereNull Object (Business Rules Scripting). This represents the SQL "null" construct.

 

method createNull: WhereBuilderWrapper

 

WhereBuilderWrapper createNull()

 

Function createNull As WhereBuilderWrapper

createParameter

Creates a WhereParameter Object (Business Rules Scripting). Parameters are stored externally and can be used to pass blobs as where expressions.

 

method createParameter(name: String; type: String; size: Int32): WhereBuilderWrapper

 

WhereBuilderWrapper createParameter(String name, String type, Int32 size)

 

Function createParameter(name As String, type As String, size As Int32) As WhereBuilderWrapper

Parameters:

  • name:
  • type:
  • size:

createUnary

 

method createUnary(value: WhereBuilderWrapper; operator: String): WhereBuilderWrapper

 

WhereBuilderWrapper createUnary(WhereBuilderWrapper value, String operator)

 

Function createUnary(value As WhereBuilderWrapper, operator As String) As WhereBuilderWrapper

Parameters:

  • value:
  • operator:

See Also