What are the Various ExpressionColumn Options

3 Jan 20201 minute to read

The following code illustrates various expression column options.

C#

//1. Sets the operators in the expression.

//The computations are performed with level one operations done first.

//Alpha constants used with match and like should be enclosed in apostrophes ('). 

// *, / ,+, - ,<, >, =, <=, >=,match, like, in, between ,or, and 

// * operator used here.
ExpressionFieldDescriptor exp= new ExpressionFieldDescriptor("Expr1","[ColumnName] *2", "System.Int32");

//2. Sets the output/view type.

//Output in double type.
ExpressionFieldDescriptor exp= new ExpressionFieldDescriptor("Expr1","[ColumnName] *2", "System.Double");

VB.NET

' 1. Sets the operators in the expression. 

' Sets operators in the expression.  

' The computations are performed with level one operations done first.                      

' Alpha constants used with match and like should be enclosed in apostrophes ('). 

' *, / ,+, - ,<, >, =, <=, >=,match, like, in, between ,or, and 

' * operator used here.
Dim exp As ExpressionFieldDescriptor = New ExpressionFieldDescriptor("Expr1", "[Id] *2", "System.Int32")

' 2. Sets the output in double type.
Dim exp2 As ExpressionFieldDescriptor = New ExpressionFieldDescriptor("Expr2", "[Expr1] *2", "System.Double")