Progress Operators

Top  Previous  Next  

The following list details initial information of some Progress Operators that can be used. Additional information is available at OpenEdge ABL Reference

Operator

Description

Usage

+

Adds two numeric expressions

expression + expression

expression
Any expression resulting in a numeric value

+

Joins two character string or expressions

expression + expression

expression
Any expression resulting in a character or string value

+

Adds a number days to a date

date + days

date
Any expression that results in a date

days
Any expression with an integer value

-

Subtracts a numeric expression from another

expression - expression

expression
Any expression resulting in a numeric value

-

Subtracts a number of  days, or a date, from a date

date - days
date - date

date
Any expression that results in a date

days
Any expression with an integer value

*

Multiplies two numeric expressions

expression * expression

expression
Any expression resulting in a numeric value

/

Divides one numeric expression by another numeric expression

expression / expression

expression
Any expression resulting in a numeric value

AND

Returns TRUE if each logical expression is true

expression AND expression

expression
Any expression resulting in a logical value (TRUE or FALSE)

EQ

=

Returns a True value if two expressions are equal

expression EQ expression
expression = expression

expression
A field name or expression. The data types on each side must be the same

GE

>=

Returns a True value if  the first expression is greater or equal to the  second

expression GE expression
expression >= expression

expression
A field name or expression. The data types on each side must be the same

GT

>

Returns a True value if  the first expression is greater than the second

expression GT expression
expression > expression

expression
A field name or expression. The data types on each side must be the same

LE

<=

Returns a True value if  the first expression is less then or equal to the second

expression LE expression
expression <= expression

expression
A field name or expression. The data types on each side must be the same

LT

<

Returns a True value if  the first expression is less than the second

expression LT expression
expression < expression

expression
A field name or expression. The data types on each side must be the same

NE

<>

Returns a TRUE value if two expression are not equal

expression NE expression
expression <> expression

expression
A field name or expression. The data types on each side must be the same

NOT

Returns TRUE if the expression is false and FALSE if the expression is true

NOT expression

expression
Any expression resulting in a logical value (TRUE or FALSE)

OR

Returns a TRUE value if either of two logical expression are TRUE

expression OR expression

expression
Any expression resulting in a logical value (TRUE or FALSE)

 

 

 


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0