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.
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 -