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.
Simple Message Pop-UP to give feedback and for interaction with user
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).
Lookup a field value in a table using an ad hoc query
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
The ceil function rounds up a numeric value to the next integer.
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.
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.
Copies selected record(s)
Copies selected data to clipboard
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.
Ad-hoc (Runtime) creation of a table for sorting, backup, temporary tables etc.
The current keyword lets you access any of the eleven system defined variables summarized below and on the following page.
Deletes selected data from current form and copies to clipboard
Export Data from CURRENT Multiview
The date function constructs a date value from three separate numeric values.
Simply pick a date in a field via a datepicker widget.
The day function extracts the day of the month (1-31) from a date value.
DataEase Operating System - Navigating in the DataEase environment. Migration/Conversion/FileOpen/New applications etc.
Switch current document to design mode
Close the Current Document.
Close any Document from another Document, procedure etc.
Delete a Document in the application
Open a Document (Form, Report, Procedure)
Check if a named object exist in the current Document
Execute the content of a string as a derivation.
To run a DQL script as a function from anywhere.
The exp function calculates the exponential value of a numeric value.
Clears current field
To run a DQL script stored in a text file as a function from anywhere.
Display all records regardless of selection filter/sort order.
Display records according to the specified selection filter/sort order.
The firstc function extracts a specified number of characters (n) from the beginning (left) of a text value.
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).
The firstw function extracts a specified number of words from the beginning (left) of a text value.
FixedWidth return a space (blank) padded string "Length" long where Value is positioned according to the position switch.
The floor function rounds down a numeric value to the next lowest integer.
Clear the current form
To open a document filtered by the relational constraint.
Reorganize one or all tables in the application
The futurevalue function calculates the final value of a financial transaction given the presentvalue, installment payment, interest rate, and number of payment periods.
Supplement to current, get current file paths to App, De and My Documents.
Get the content (text) of a label, button or Tab
Get the current style of an object.
To get the value of a field.
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
The hours function extracts the hour from a time value expressed in a 24-hour format.
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.
To control the index building to increase speed and insure consistency before and during big transactions (DQL). 8.5 Onwards Only!
The installment function calculates the periodic installment payment required for a financial transaction given the presentvalue, futurevalue, interest rate, and number of payment periods.
Allow call to interupthandler in servicewindow
The jointext function combines two separate text values into one.
Trigger a File Menu Action from programming. HTML only.
To execute a PRISM derivation from a HTML document and return the result
To Set a field value in the form from a HTMLobject
The julian function converts a date value to a Julian date.
Store a DQL in a lable in your form and simply execute it from a button or derivation.
The lastc function extracts a specified number of characters from the end (right) of a text value.
The lastfirst function converts a text value from the format: First Name [M.] Last Name to the format: Last Name, First Name [M.].
The lastw function extracts a specified number of words from the end (right) of a text value.
The length function counts the number of character positions in a text value.
The log function computes the natural base e logarithm of a numeric value.
The log10 function computes the common base 10 logarithm of a numeric value.
Displays the Lookup dialog if a table is specified. If no table is specified the Table dialog displays first.
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
Unwinds a Memo into 256 bytes "chunks" so it can be saved or manipulated by "normal" DataEase functions.
Copies, Appends or Inserts a Field or a constant into a Memo field.
Function to decode a value pair in a memo. Very usefull for saving unstructured data in Memo and retrieving it.
To execute a DQL script stored in a Memo field
Returns a number larger than 0 if the string searched for is contained in the memo field.
Read a Global Memo Variable and set it into a named Memo field.
Returns the lengt of a memo in characters.
This function copies, appends, or inserts a Memo into another Memo.
Replace a TAG in a Memo with the content of another Memo
Reads the content of a file into a memo.
To replace all occurrences of a string in a Memo with another string.
Set the content in a Memo as a Global Variable.
Returns the String between two search values in a Memo
Return the remainder of a Memo after Search
Return the content of a Memo up to search.
Returns the number of words in a given Memo.
Write the content of a Memo to a file.
Will show a Windows Message Dialog with options
The midc function extracts a specified number of characters from the middle of a text value.
The midw function extracts a specified number of words from the middle of a text value.
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.
The month function extracts the month (1- 12) from a date value.
Move any Form object and/or resize it
Open New Form Dialogue
Open New ProcedureDialogue
Open New Report Dialogue
Goes to the next record
Open a Form in the current app. Obsolete: Use DocumentOpen instead.
Open a Menu document. Obsolete! Use DocumetnOpen Instead
Open a Procedure in the current app. Obsolete: Use DocumentOpen instead.
Open a Report (QBM) n the current app. Obsolete: Use DocumentOpen instead.
Pastes data from the clipboard
The percent operator calculates the percentage of records that satisfy a condition specified by a comparison of two values.
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.
The power function raises a numeric value to a specified power.
The presentvalue function calculates the required starting amount for a financial transaction given the futurevalue, installment payment, interest rate, and number of payment periods.
Print the current document
Displays printer setup dialog
Prints the content of a file directly as HTML. Can print any HTML file ex. export from MemoWriteToFile
Print the content of a Memo field as HTML i.e. formated printing.
Prints current document in zoomed out mode
The proper function converts the first letter in each word in a text value to uppercase.
Display the QBM dialogue with MultiView from current document pre-selected
The random function returns a random decimal value between 0 and 1 (inclusive). No value is required in the function's argument.
The rate function calculates the interest rate of a financial transaction given the presentvalue, futurevalue, installment payment, and the number of payment periods.
Read the content of a file and return it.
Deletes current record
Goes to the first record.
Goes to the last record
Goes to the previous record
Rstores deleted record
Save the current record (Update and Save)
Save the current record as new (Copy)
Refresh the form in accordance with the content of the temporary record, do not reread from file.
Refresh the form with the latest saved data on the table/record.
Function that will automatically refresh all status/info/system documents in DE8.
To retrieve and save data to a remote DataEase Server.
Closes the current document and returns focus to the parent document.
The seconds function extracts the seconds from a time value expressed in 24-hour format.
To set the selection filter on the main table in a form
Sending emails from anywhere inside a DataEase application.
Alternative Way of sending email from DE8 including TLS authenticaton.
Sets the fill, border or font color of a field or a button.
To Set Properties and Environment variables in DataEase Environment. Opposite of GetCurrent()
Move the cursor/focus to another field/button programatically.
Will allow you to change the text on a label, button or tab from anywhere in DataEase 8.
Set the value of a Memo GUI Object with the content of a PRISM Memo Column.
Sets the fill, border or font color of a field or a button.
GAME CHANGER! Set the Style of an object from a function in RT.
Set the value of another field from a field or a button.
Set any global variable with name. Finally an internal feature.
The sin function calculates the sine of an angle expressed in radians.
The sinh function calculates the hyperbolic sine of an angle expressed in radians.
The spellcurrency function spells the monetary equivalent of a numeric value.
The spelldate function spells a date value in common form.
The spellmonth function spells the name of the month that corresponds to a numeric value from 1 (January) to 12 (December).
The spellnumber function spells the integer portion of a numeric value.
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.
Return the text between two search strings in a string
Fall back function for new String Escape functionaltiy. Force Escaping of 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.
Returnn the remainder of a string after search (Search is from tail)
Replace a string inside a string with a new 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.
The textpos function returns the first position of a substring in a specified text value.
To find the starting position of a search string in a string.
Return properties on the object that call the function
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.
Function that converts any DataEase value to Text.
Undo the last action
Simply generate a guaranteed unique id to be used as key in a record. Don't use SEQUENCE FROM!
The upper function converts each letter in a text value to uppercase.
Set document to be displayed in single record format - Form mode.
Display multiple records in a tabular format - Table View
To delay before executing the next function/command/action.
The weekday function converts a date value to an integer that corresponds to the day of the week from 1 (Monday) to 7 (Sunday).
Create, Overwrite or append to a text file.
The year function extracts the year from a date value.
The yearday function converts a date value to the Julian day of the year (1-366).
The yearweek function calculates the week number (1-53) of a date value.
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.