$isupper

Tests if the letters in a character string are uppercase.

Syntax

$isupper(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is uppercase, i.e., contains no lowercase letters.

Example

$isupper("aBC")

Evaluates to $False.

$isupper(43)

Evaluates to $True.

See Also

$isalphabetic

$isalphanumeric

$isdate

$isdigit

$islower

$isnumber

$iszimname

About Character Literals

About Functional Expressions

$isalphabetic

Tests if a character string contains only letters.

Syntax

$isalphabetic(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is alphabetic.

Example

$isalphabetic("abc")

Evaluates to $True.

$isalphabetic("abc1")

Evaluates to $False.

See Also

$isalphanumeric

$isdate

$isdigit

$islower

$isnumber

$isupper

$iszimname

Character Literals

Functional Expressions

$islower

Tests if the letters in a character string are lowercase.

Syntax

$islower(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is lower case, i.e., contains no uppercase letters.

Example

$islower("Abc")

Evaluates to $False.

$islower(34)

Evaluates to $True.

See Also

$isalphabetic

$isalphanumeric

$isdate

$isdigit

$isnumber

$isupper

$iszimname

About Character Literals

About Functional Expressions

$value

Provides a default value for an expression that can be $Null.

Syntax

$value(expression1,expression2)

Parameters

expression1any expression
expression2any expression

Return Value

Same as the selected expression.

Comments

If expression1 is not $Null, $value returns the value of expression1; otherwise, it returns the value of expression2.

Example

detail line "Employee Number: " $value(EmpNum,"N/A")

Traps $Null values in a report and replaces them with “N/A”.

See Also

About Functional Expressions

CASE

Expressions and the $Null Property

IS [NOT] [$]NULL

BREAK (Loops)

Exits from a WHILE loop.

Syntax

BREAK

Comments

Upon encountering a BREAK command, the software continues execution at the first command following the ENDWHILE of the “innermost WHILE loop” containing the BREAK.

Any IF or CASE statements that are still open when a BREAK command is executed are automatically closed.

Example

Consider the following code fragment:

while var1 > 20

.. some commands …

if var2 = 1

break

else

 … more commands …

endif

 … still more commands …

endwhile

… commands after the WHILE loop …

When var2 is set to 1, the only commands executed in the above sequence are “some commands” and “commands after the WHILE loop”. Commands between the BREAK and ENDWHILE commands are ignored, and the “open” IF statement is automatically closed.

See Also

CONTINUE

GOTO

WHILE

$dayname

Determines the day name associated with a specified date value.

Syntax

$dayname(date)

Parameters

datea data, or an expression that evaluates to a date, in the form YYYYMMDD

Return Value

Character string.

Comments

This function extracts day information from standard date values. Date is often the system variable $Date.

The values returned by the $dayname function can be altered with the Language Customizer utility.

Example

$dayname (19991225)

Evaluates to “Saturday”.

$dayname ($date+7)

Evaluates to “Saturday” when $Date is 19991225.

See Also

$Date

$day

$month

$monthname

$weekday

$year

$isalphanumeric

Tests if a character string contains only letters and digits.

Syntax

$isalphanumeric(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

1-character binary string. Evaluates to 1 ($True) if string meets the validation test; otherwise, evaluates to 0 ($False).

Comments

This function tests if a particular character string is alphanumeric.

Example

$isalphanumeric("abc1")

Evaluates to $True.

$isalphanumeric("abc ")

Evaluates to $False.

See Also

$isalphabetic

$isdate

$isdigit

$isdigit

$isnumber

$isupper

$iszimname

$trim

Character Literals

Functional Expressions

$leftjustify

Left-justifies a character string.

Syntax

$leftjustify(string)

Parameters

stringa character string or an expression that evaluates to a character string

Return Value

Character string.

Comments

String is left-justified in a space that is $length(string) characters long. Leading spaces in string are ignored.

Example

$leftjustify(" abcde")

Evaluates to “abcde “.

$leftjustify(var1)

Evaluates to “3 ” if var1 is a LONGINT variable whose value is 3 (occupies 12 character spaces when converted to a string).

See Also

$center

$rightjustify

About Character Literals

About Functional Expressions

Conversion Between Data Types

SCREEN CLEAR

Clears the screen and establishes the application window (BACKSCREEN) as the current window.

Syntax

SCREEN CLEAR

Comments

The SCREEN CLEAR command clears the contents of the application window (BACKSCREEN), hides any other windows that are currently displayed, makes the application window the current window, and places the cursor at the top, left-hand corner of the application window.

Although hidden, all other windows remain open and active. To re-display the hidden windows, use either the SCREEN RESET or WINDOW DISPLAY BACKSCREEN HIDE command.

Example

window clear backscreen

window set current backscreen

window display backscreen

The SCREEN CLEAR command is equivalent to the preceding sequence of commands.

screen clear   % clear prev. data & expose application window

output “Output to printer? (y/n)” ;

input Response

if Response = “y”

 set output printer

endif

screen reset

See Also

CLEAR

WINDOW CLEAR

en_CAEnglish