Progress Commands Quiz

What does the ACCUM function do?

Returns a TRUE value if the first of the two expressions is less than the second

Returns value of aggregate expression calculated by Accumulate

Compares two expressions and returns a TRUE value if they are not equal

Returns a random integer value between two integers (inclusive)

What does the Accumulate function do?

Returns TRUE if last find statement for a record returns more than one record

Replace a string with sepcified substring replacements

Calculates one or more aggregate values of an expression

Returns the square rot (as a decimal) of the expression you specify

What does Ambiguous function do?

Returns, as an integer value, the number of rows currently in the results list of a scrolling query

Returns a true value if the current block is being processed after a previous undo

Returns TRUE if last find statement for a record returns more than one record

Converts a value of any data type into a character value

What does the Available function do?

Verifies that a record compiles with mandatory field and unique index definitions. It clears the record from the buffer and unites it to the database if it has been changed

Returns TRUE if record buffer contains a record, and FALSE if the record buffer is empty

Determines the remainder after division

Returns the square rot (as a decimal) of the expression you specify

FIRST-OF function

Returns a TRUE value if either of the two logical expressions is TRUE

Returns a random integer value between two integers (inclusive)

Returns a TRUE value if the current iteration of a DO, FOR EACH, or REPEAT... BREAK block is the first iteration for a new break group and modifies all three block types.

Begins a block of statements that are processed repeatedly until the block ends in one of several ways. Use an end statement to end a REPEAT block

PRESELECT phrase

Returns an Integer representing the time as a number of seconds since midnight.

Removed leading and trailing white space, or other specified characters from a character or longchar

Specifies a set of records to preselect for a do or repeat block

Backs out all modifications to fields and variables made during a current iteration of a block, and what to do next

SUBSTRING function

Begins a block of statements that are processed repeatedly until the block ends in one of several ways. Use an end statement to end a REPEAT block

Inserts content from a specified expression into a field or variable, optionally replacing exisitng chars, bytes, or columns

Returns a TRUE value if the first of the two expressions is less than the second

Returns an INTEGER value representing the time in miliseconds from the datetime expression

UNDO statement

Begins a block of statements that are processed repeatedly until the block ends in one of several ways. Use an end statement to end a REPEAT block

Backs out all modifications to fields and variables made during a current iteration of a block, and what to do next

Determines the remainder after division

Returns an INTEGER value of the number of bytes, characters, or columns in a string

SUBSTRING statement

Extracts a portion of a character string from a field or variable

Inserts content from a specified expression into a field or variable, optionally replacing exisitng chars, bytes, or columns

Returns the square rot (as a decimal) of the expression you specify

Replace a string with sepcified substring replacements

INTERVAL function

Returns an Integer representing the time as a number of seconds since midnight.

Returns the time interval between two DATE, DATETIME, DATETIME-TZ

Returns an integer value representing timezone offset from UTC in minutes

Returns a random integer value between two integers (inclusive)

Unlock and Upgrade

Remove all limits from your Quizzes

Progress Commands Quiz

More Quizzes