Several groups of functions are available in Expression Designer. It is possible to use data functions, math functions, date functions, environment functions, login functions, etc. The wide variety of functions enables the developer to create even the most sophisticated expression.

The detailed description of the function, along with function syntax is also available in design time at the bottom of the Expression Designer.

Data Functions

Function	Description
Null	Returns null value.
IsNull	Function has one parameter which is evaluated as an expression. Function returns True if executed expression is null.
Convert	Converts a specified expression to desirable data type.
Eval	Evaluates an expression which is provided as a parameter.

Math Functions

Many math functions are available which can be used for data calculation. Developer can use standard functions such as Abs, Sin, Cos, Min, Max, Sqrt, etc.

Date Functions

Data functions are used for manipulating with data and time values.

Function	Description
DateAdd	Returns a new date time value based on adding interval to the specific component of the date time value.
Now	Returns current system date and time value.
Today	Returns current system date value.
UTCNow	Returns current system date and time value expressed as the Coordinated Universal Time (OTC).

Environment Functions

Environment Functions depend on workplace and workstation.

Function	Description
WorkplaceId	Returns the number of workplace currently logged on.
WorkstationName	Returns the name of the workstation on which the application is currently running.

Login Functions

Login functions provide data about user currently logged in the application.

Function	Description
LoginId	Returns the login number of currently logged user.
UserId	Returns the identity number of currently logged user.
UsernName	Returns the user name of currently logged user.
WinUserName	Returns the user name of currently logged user into operating system.
DomainName	Returns the domain name to which workstation or laptop belongs.

Statement Function

Statement function is a branch function with similar effect as an if clause in any programming language.

Function	Description
If	Returns one of the values specified as parameters. The return value depends on the result of the executed expression.

Adapter Functions

Adapter function determines current state and behavior of the adapter.

Function	Description
IsAdding	Returns True if a specified data source is in adding mode.
IsEditing	Returns True if a specified data source is in editing mode (but not in adding mode).
RecordCount	Returns the number of currently loaded records in the specific data source. Data source is given as a parameter.
RecordIndex	Returns the index of currently selected record in a data source.
Sum	Calculates data for the specified field based on the condition set and returns summary.
HasError	Returns True if specified data source has error.

See Also