Operators & expressions

Supported operators and expressions

  • Arithmetic operators for numeric data types: +, -, *, /, ^, ++, --, +=, -=, *=, /=, ^=

  • Relational operators for all data types: =, >, <, <>, >=, <=, NOT, AND, OR

  • The concatenation operator for String data types: +

  • DataWindow expressions are supported

  • The supported features of operators & expressions are related to null values and forced conversion.

Precedence of supported operators

These operators will follow the order of precedence listed in the table below:

Table 170. 

Order

Operator

Purpose

1

( )

Grouping

2

+, -, NOT

Unary plus (indicates positive number), unary minus (indicates negative number), Negation

3

^

Exponentiation

4

*, /

Multiplication and division

5

+, -

Addition and subtraction; string concatenation

6

>, <, <=, >=

Relational operators

7

=,

Relational operators

8

AND

Logical and

9

OR

Logical or


Unsupported

Avoid data overflow in the application. If there is data overflow, the mobile application handles the data differently from the PowerBuilder application.