Easy to Create, Easy to Change - Easy to use!

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)

DocumentRun [Action]
Execute a Document to produce a document ex. PDF or Email

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.

application status -

assign -

backup db (backup database) -

call menu -

call program -

case -

copy all from -

db status (database status) -

define -

do -

else -

end -

enter a record -

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 -

input using -

install application -

list records -

lock -

lock db (lock database) -

message -

Modify Records -

OML Alphabetical Command List -

others -

output -

Procedural Commands -

query selection -

record entry -

reorganize -

restore db (restore database) -

run procedure -

unlock -

unlock db (unlock database) -

value -

while -

CutSelected

Message