Expressions

Overview

An expression is a combination of one or more values, operators and SQL functions that evaluate to a value. You can also use them to query the database for a specific set of data. Expressions can be used on forms with Query control and in scripting with $Database methods.

Remarks

Expressions can consist of multiple SQL functions. The following functions are available;

ValueDescription
CountCount of row values.
CountDistinctCount of distinct values in rows.
SumSum of row values. Valid for numeric type columns.
SumDistinctSum of distinct values in rows. Valid for numeric type columns.
AvgAverage of row values. Valid for numeric type columns.
AvgDistinctAverage of distinct values in rows. Valid for numeric type columns.
MinMinimum value in rows.
MaxMaximum value in row values.
StdDevStandard deviation of row values.
DateDiffDifference between two date values. Valid for date and datetime type columns.
DatePartCrops out the specified part of date values and gives the kept part as number value. Valid for date and datetime type columns.
DateTruncTruncates date values except the specified date part and gives a date value. Valid for date and datetime type columns.

Copyright © 2010 - 2023 Emakin. All rights reserved.