Abs (absolute value) [Mathematical]

The abs function converts a numeric value to a positive, unsigned numeric value.

Acos (arccosine) [Mathematical]

The acos function calculates the arccosine of a numeric value. The result is an angle expressed in radians between 0 and p.

Alert [Internal]

Simple Message Pop-UP to give feedback and for interaction with user

AmPm [DateTime]

The ampm function evaluates a value expressed in the 24-hour time format (HH:MM:SS) and returns the appropriate abbreviation AM (before noon), or PM (after noon).

AnyLookup [String]

Lookup a field value in a table using an ad hoc query

ApplicationClose [Action]

Closes application

Asin (arcsine) [Mathematical]

The asin function calculates the arcsine of a numeric value. The result is an angle expressed in radians between -p/2 to p/2.

Atan (arctangent) [Mathematical]

The atan function calculates the arctangent of a numeric value. The result is an angle expressed in radians between -p/2 to p/2.

Atan2 (arctangent 2) [Mathematical]

The atan2 function calculates the arctangent of Value 1 divided by Value 2

Ceil [Mathematical]

The ceil function rounds up a numeric value to the next integer.

Chr [String]

Simply returns the ASCII value for a number. Something we should have had all the time. Very useful for inserting " and new line in Memos and oither fields.

ConCat [String]

The Concat function combines two or more separate text values into one. Concat performs the same function as Jointext, but is simpler to use. Concat - short for concatenation - joins two or more strings together into a single string.

CopyRecord [Action]

Copies selected record(s)

CopySelected [Action]

Copies selected data to clipboard

CopySpecial [Action]

Copies selected data values to the clipboard

Cos (cosine) [Mathematical]

The cos function calculates the cosine of an angle expressed in radians. The value returned ranges between -1 and 1.

CosH (Hyperbolic cosine) [Mathematical]

The cosh function calculates the hyperbolic cosine of an angle expressed in radians.

Count Of [Internal]

The count of operator counts how many records in a related table match the specified selection criteria. The result can appear as a list item in the detail area of a report or as a statistic in the summary area at the end of a report.

Create [Internal]

Ad-hoc (Runtime) creation of a table for sorting, backup, temporary tables etc.

Current [Internal]

The current keyword lets you access any of the eleven system defined variables summarized below and on the following page.

CutSelected [CDF]

Deletes selected data from current form and copies to clipboard

DataExport [Action]

Export Data from CURRENT Multiview

DataImport [Action]

Imports data

DataImport [Action]

Imports data

Date [DateTime]

The date function constructs a date value from three separate numeric values.

DatePicker [Internal]

Simply pick a date in a field via a datepicker widget.

Day [DateTime]

The day function extracts the day of the month (1-31) from a date value.

DEOS [Internal]

DataEase Operating System - Navigating in the DataEase environment. Migration/Conversion/FileOpen/New applications etc.

DesignerView [Action]

Switch current document to design mode

DocumentClose [Action]

Close the Current Document.

DocumentCloseName [Internal]

Close any Document from another Document, procedure etc.

DocumentDelete [Action]

Delete a Document in the application

DocumentOpen [Action]

Open a Document (Form, Report, Procedure)

DoesObjectExist [Internal]

Check if a named object exist in the current Document

ExecDerivation [Internal]

Execute the content of a string as a derivation.

ExecDQL [Internal]

To run a DQL script as a function from anywhere.

ExitDataEase [Action]

Closes DFW

Exp [Mathematical]

The exp function calculates the exponential value of a numeric value.

FieldClear [Action]

Clears current field

FileExecDQL [File]

To run a DQL script stored in a text file as a function from anywhere.

FilterClear [Action]

Display all records regardless of selection filter/sort order.

FilterSet [Action]

Display records according to the specified selection filter/sort order.

FirstC [String]

The firstc function extracts a specified number of characters (n) from the beginning (left) of a text value.

FirstLast [String]

The firstlast function converts a text value from the format: LastName, FirstName[M.] to the format: FirstName[M.]LastName. The [M.] is an optional middle initial (or name).

FirstW [String]

The firstw function extracts a specified number of words from the beginning (left) of a text value.

FixedWidth [String]

FixedWidth return a space (blank) padded string "Length" long where Value is positioned according to the position switch.

Floor [Mathematical]

The floor function rounds down a numeric value to the next lowest integer.

FormClear [Action]

Clear the current form

FormOpenRelated [Action]

To open a document filtered by the relational constraint.

FormReorganize [Action]

Reorganize one or all tables in the application

FutureValue [Mathematical]

The futurevalue function calculates the final value of a financial transaction given the presentvalue, installment payment, interest rate, and number of payment periods.

GetCurrent [Internal]

Supplement to current, get current file paths to App, De and My Documents.

GetlabelText [Internal]

Get the content (text) of a label, button or Tab

GetStyle [Internal]

Get the current style of an object.

GetValue [Internal]

To get the value of a field.

GetVar [Internal]

Get any global variable by name. Finally an internal feature.

Highest Of [Internal]

The highest of operator finds the highest value in a specified field in all matching records in a related table. The result can appear as a list item in the detail area of a report or as a statistic in the summary area at the end of each group or the end

Hours [DateTime]

The hours function extracts the hour from a time value expressed in a 24-hour format.

HtmlToPDF [Internal]

To convert HTML output to PDF or merger several PDF files into 1.

If Function [Conditional]

The if function evaluates a specified condition and returns one of two specified values based on whether the condition is true or false.

IndexUpdate [Internal]

To control the index building to increase speed and insure consistency before and during big transactions (DQL). 8.5 Onwards Only!

Installment [Mathematical]

The installment function calculates the periodic installment payment required for a financial transaction given the presentvalue, futurevalue, interest rate, and number of payment periods.

Int21 [Internal]

Allow call to interupthandler in servicewindow

JoinText [String]

The jointext function combines two separate text values into one.

jsAction []

Trigger a File Menu Action from programming. HTML only.

jsDerivation [Internal]

To execute a PRISM derivation from a HTML document and return the result

jsSetValue [Internal]

To Set a field value in the form from a HTMLobject

Julian [DateTime]

The julian function converts a date value to a Julian date.

LabelExecDQL [Internal]

Store a DQL in a lable in your form and simply execute it from a button or derivation.

LastC [String]

The lastc function extracts a specified number of characters from the end (right) of a text value.

LastFirst [String]

The lastfirst function converts a text value from the format: First Name [M.] Last Name to the format: Last Name, First Name [M.].

LastW [String]

The lastw function extracts a specified number of words from the end (right) of a text value.

Length [String]

The length function counts the number of character positions in a text value.

Log [Mathematical]

The log function computes the natural base e logarithm of a numeric value.

Log10 [Mathematical]

The log10 function computes the common base 10 logarithm of a numeric value.

LookupTo [Action]

Displays the Lookup dialog if a table is specified. If no table is specified the Table dialog displays first.

Lower [String]

The lower function converts each letter in a specified text value into lower-case type.

Lowest Of [Internal]

The lowest of operator finds the smallest value in the specified field in all matching records in a related table. The result can appear as a list item in the detail area of a report or as a statistic at the end of each group or at the end of the report.

Mean Of [Internal]

The mean of operator calculates the average value in a specified field in all matching records in a related table. The result can appear as a list item in the detail area of a report or as a statistic in the summary area at the end of each group or at the

MemoChunk [Memo]

Unwinds a Memo into 256 bytes "chunks" so it can be saved or manipulated by "normal" DataEase functions.

MemoCopy [Memo]

Copies, Appends or Inserts a Field or a constant into a Memo field.

MemoDecodePair [Memo]

Function to decode a value pair in a memo. Very usefull for saving unstructured data in Memo and retrieving it.

MemoExecDQL [Memo]

To execute a DQL script stored in a Memo field

MemoFind [Memo]

Returns a number larger than 0 if the string searched for is contained in the memo field.

MemoGetGlobal() [Memo]

Read a Global Memo Variable and set it into a named Memo field.

MemoLength [Memo]

Returns the lengt of a memo in characters.

MemoMemoCopy [Memo]

This function copies, appends, or inserts a Memo into another Memo.

MemoMemoReplace [Memo]

Replace a TAG in a Memo with the content of another Memo

MemoReadFromFile [File]

Reads the content of a file into a memo.

MemoReplace [Memo]

To replace all occurrences of a string in a Memo with another string.

MemoSetGlobal() [Memo]

Set the content in a Memo as a Global Variable.

MemoStringBetween [Memo]

Returns the String between two search values in a Memo

MemoStringFrom [Memo]

Return the remainder of a Memo after Search

MemoStringTo [Memo]

Return the content of a Memo up to search.

MemoWordCount [Memo]

Returns the number of words in a given Memo.

MemoWriteToFile [Memo]

Write the content of a Memo to a file.

Message [CDF]

Will show a Windows Message Dialog with options

MidC [String]

The midc function extracts a specified number of characters from the middle of a text value.

MidW [String]

The midw function extracts a specified number of words from the middle of a text value.

Minutes [DateTime]

The minutes function extracts the minutes from a time value expressed in a 24-hour format.

Mod (modulus) [Mathematical]

The mod (modulus) function returns the remainder when one numeric value is divided by a second numeric value. If both values are integers, an integer value is returned. Otherwise, a decimal value is returned.

Month [DateTime]

The month function extracts the month (1- 12) from a date value.

MoveObject [Internal]

Move any Form object and/or resize it

NewMenu [Action]

Open New Form Dialogue

NewProcedure [Action]

Open New ProcedureDialogue

NewReport [Action]

Open New Report Dialogue

NextRecord [Action]

Goes to the next record

OpenForm [Action]

Open a Form in the current app. Obsolete: Use DocumentOpen instead.

OpenMenu [Action]

Open a Menu document. Obsolete! Use DocumetnOpen Instead

OpenProcedure [Action]

Open a Procedure in the current app. Obsolete: Use DocumentOpen instead.

OpenReport [Action]

Open a Report (QBM) n the current app. Obsolete: Use DocumentOpen instead.

Paste [Action]

Pastes data from the clipboard

Percent [Mathematical]

The percent operator calculates the percentage of records that satisfy a condition specified by a comparison of two values.

Periods [Mathematical]

The periods function calculates how long a financial transaction requires to reach a future target value given the presentvalue, futurevalue, installment payment, and interest rate.

Power [Mathematical]

The power function raises a numeric value to a specified power.

Presentvalue [Mathematical]

The presentvalue function calculates the required starting amount for a financial transaction given the futurevalue, installment payment, interest rate, and number of payment periods.

PrintDocument [Action]

Print the current document

PrinterSetup [Action]

Displays printer setup dialog

PrintHTML [File]

Prints the content of a file directly as HTML. Can print any HTML file ex. export from MemoWriteToFile

PrintMemo [Memo]

Print the content of a Memo field as HTML i.e. formated printing.

PrintPreview [Action]

Prints current document in zoomed out mode

Proper [String]

The proper function converts the first letter in each word in a text value to uppercase.

QBM_NewReport [Action]

Display the QBM dialogue with MultiView from current document pre-selected

Random [Mathematical]

The random function returns a random decimal value between 0 and 1 (inclusive). No value is required in the function's argument.

Rate [Mathematical]

The rate function calculates the interest rate of a financial transaction given the presentvalue, futurevalue, installment payment, and the number of payment periods.

ReadFromFile [File]

Read the content of a file and return it.

RecordDelete [Action]

Deletes current record

RecordFirst [Action]

Goes to the first record.

RecordLast [Action]

Goes to the last record

RecordPrevious [Action]

Goes to the previous record

RecordRestore [Action]

Rstores deleted record

RecordSave [Action]

Save the current record (Update and Save)

RecordSaveNew [Action]

Save the current record as new (Copy)

RefreshForm [Internal]

Refresh the form in accordance with the content of the temporary record, do not reread from file.

RefreshScreen [Internal]

Refresh the form with the latest saved data on the table/record.

RefreshStatus [Internal]

Function that will automatically refresh all status/info/system documents in DE8.

Remote [Internal]

To retrieve and save data to a remote DataEase Server.

ReturnToParentDoc [Action]

Closes the current document and returns focus to the parent document.

Seconds [DateTime]

The seconds function extracts the seconds from a time value expressed in 24-hour format.

SelectionFilter [Action]

To set the selection filter on the main table in a form

Send [Internal]

Sending emails from anywhere inside a DataEase application.

SendEmail [Internal]

Alternative Way of sending email from DE8 including TLS authenticaton.

SetColor [Internal]

Sets the fill, border or font color of a field or a button.

SetCurrent [Internal]

To Set Properties and Environment variables in DataEase Environment. Opposite of GetCurrent()

SetFocus [Internal]

Move the cursor/focus to another field/button programatically.

SetLabelText [Internal]

Will allow you to change the text on a label, button or tab from anywhere in DataEase 8.

SetMemoValue [Memo]

Set the value of a Memo GUI Object with the content of a PRISM Memo Column.

SetState [Internal]

Sets the fill, border or font color of a field or a button.

SetStyle [Internal]

GAME CHANGER! Set the Style of an object from a function in RT.

SetValue [Internal]

Set the value of another field from a field or a button.

SetVar [Internal]

Set any global variable with name. Finally an internal feature.

Sin [Mathematical]

The sin function calculates the sine of an angle expressed in radians.

SinH [Mathematical]

The sinh function calculates the hyperbolic sine of an angle expressed in radians.

SpellCurrency [String]

The spellcurrency function spells the monetary equivalent of a numeric value.

SpellDate [String]

The spelldate function spells a date value in common form.

SpellMonth [String]

The spellmonth function spells the name of the month that corresponds to a numeric value from 1 (January) to 12 (December).

SpellNumber [String]

The spellnumber function spells the integer portion of a numeric value.

SpellWeekday [String]

The spellweekday function spells the name of the day that corresponds to a numeric value from 1 (Monday) to 7 (Sunday).

Std.Dev. (standard deviation) [Mathematical]

The std.dev. operator calculates the standard deviation (the square root of the variance) in a set of data. The result usually appears as a statistic in the summary area at the end of a report.

StringBetween [String]

Return the text between two search strings in a string

StringEscape [String]

Fall back function for new String Escape functionaltiy. Force Escaping of string

StringFind [String]

Returns start position of StringToFind i.e larger than 0 if a string is part of a text. Returns 0 if it isn't.

StringFrom [String]

Returnn the remainder of a string after search (Search is from tail)

StringReplace [String]

Replace a string inside a string with a new string.

StringTo [String]

Return the string up to but not including search.

Sum Of [Internal]

The sum of operator adds the values in a specified field in all matching records in a related table. The result can appear as a list item in the detail area of a report or as a statistic in the summary area at the end of each group or at the end of the re

Tan (tangent) [Mathematical]

The tan function calculates the tangent of an angle expressed in radians.

TanH (hyperbolic tangent) [Mathematical]

The tanh function calculates the hyperbolic tangent of an angle expressed in radians.

TextPos [String]

The textpos function returns the first position of a substring in a specified text value.

Textpos []

To find the starting position of a search string in a string.

This [Internal]

Return properties on the object that call the function

TimeAmPm [DateTime]

The timeampm function converts a time value from a 24-hour format to a 12-hour format and appends the appropriate AM or PM designation.

ToText [String]

Function that converts any DataEase value to Text.

UndoEdit [Action]

Undo the last action

UniqueID [Internal]

Simply generate a guaranteed unique id to be used as key in a record. Don't use SEQUENCE FROM!

Upper [String]

The upper function converts each letter in a text value to uppercase.

ViewAsForm [Action]

Set document to be displayed in single record format - Form mode.

ViewAsTable [Action]

Display multiple records in a tabular format - Table View

Wait [Internal]

To delay before executing the next function/command/action.

WeekDay [DateTime]

The weekday function converts a date value to an integer that corresponds to the day of the week from 1 (Monday) to 7 (Sunday).

WriteToFile [File]

Create, Overwrite or append to a text file.

Year [DateTime]

The year function extracts the year from a date value.

YearDay [DateTime]

The yearday function converts a date value to the Julian day of the year (1-366).

YearWeek [DateTime]

The yearweek function calculates the week number (1-53) of a date value.

assign -

case -

define -

do -

else -

end -

exit -

Export to variable file name -

for -

if Command - The if command executes one of two different actions (or series of actions) based on whether a specified condition is true or false.

import -

lock -

message -

OML Alphabetical Command List -

others -

output -

restore db (restore database) -

unlock -

value -

while -