Inline Functions - Special Considerations

Date Times and Time Spans

The only operator that is valid for two date times is subtraction, which will result in a time span.

Time spans can be added, subtracted and negated.

Time spans can be added or subtracted from date times, which will result in a date time.

Text and Field Parts

Field parts should not be nested inside of text literals. The following method is recommended:

"Dear " & <field part> & ",

We would like to thank you for your purchase of """ & <field part> & """.

Management."

Numbers in Text

Text literals can be used instead of numbers, only when:

They are being used with an inset (in the middle of) operator.
The literal/value on the other side of the operator is a number.

For example, the following expressions are valid:

"5" + 1
"1.1" + 1
"2" > 3
<string field part> + 5

Errors will not be reported in the expression builder. Errors are only reported at runtime.

Field Parts

Field parts need to have a pre-determined type; as such, field parts with the type “Object” or “Variant” will need to be converted to a well-known type before use. Note that Inline Functions can be automatically converted by selecting the correct type within the wizard.