Translates data from one character set to another.
$ansitodos(string)| string | a character string or an expression that evaluates to a character string |
Converts the data in string from the ANSII character set to the OEM character set.
Translates data from one character set to another.
$dostoansi(string)| string | a character string or an expression that evaluates to a character string |
Converts the data in string from the OEM character set to the ANSII character set.
The current time.
$time
A number. Cannot be reset by an application program.
The current time (format: HHMMSSTT, 24-hour notation), as set in the operating system.
Some operating systems provide time only to the nearest second. In such cases, the TT (ticks) portion of the time is always set to 00.
The error code generated by the last command executed.
$errcode
A number (0 to 9999.) Can be reset by an application program.
Indicator of success (0) or a reason (1 to 9999) for the failure of the most recently executed command.
Explanations for many error codes are contained in the ErrorHelp entity set, which you can access from your database application using the DESCERR or EXPLERR utility program.
Calculates an exponential value of the natural base (e).
$exp(number)| number | a number or an expression that evaluates to a number |
Number, with the same number of decimal places as number.
$exp(2.000)
The above expression means “the natural base e, squared” and evaluates to 7.389.
Returns the last Automatic Sequence Number applied.
$ ZimSeqNum
Number, representing an Automatic Sequence Number or $Null in case of an error.
The value returned by $ ZimSeqNum is taken from the most recent ASN used. Notice that when the ADD command adds more than one record, $ ZimSeqNum will contain the value of the last record added.
$ ZimSeqNum also returns the number set using SET SEQUENCENUMBER MyEnt . Upon execution of SET SEQUENCENUMBER MyEnt ON, $ZimSeqNum returns the next number available. The $ZimSeqNum result after executing SET SEQUENCENUMBER ALL ON is undefined.
If all ADD statements refer to objects that contain ASN, the $ZimSeqNum will return the value taken by the last ADD:
ADD 1 Customers ...
ADD 100 MyEnt from MyDoc ...output $ZimSeqNumTranslates carriage return/line feed sequences.
SET EOLNTRANSLATE string
| string | Any expression that evaluates to a character string from one to five characters in length. If string is longer than five characters, only the first five characters are used. |
If the software encounters a carriage return/line feed combination in a database field when outputting that field to an application document, the carriage return/line feed combination is substituted for string. If the software encounters string during a read of an application document, the string generates a carriage return/line feed combination.
In operations that write data to an application document, the software substitutes the specified EOLTRANSLATE string for each carriage return/line feed sequence detected in the output from a single field. In operations that read data from an application document, the software substitutes a carriage return/line feed sequence for each EOLTRANSLATE string it detects in a single field.
Calculates a time value by adding hours to (or subtracting hours from) a specified time value.
$addhours(time,number)
where
| time | an 8-digit number, or an expression that evaluates to an 8-digit number, that expresses a valid time value in the format HHMMSSTT |
| number | a number, or an expression that evaluates to a number |
Number, representing a time value.
Use $addhours to perform arithmetic with time values. The $addhours function calculates a time value by adding a number representing hours to a time value. If number is negative, the effect is to subtract the hours from the time.
If $Time has the value 22503075, then
$addhours($time,1)
Evaluates to 23503075.
$addhours($time,2)
Evaluates to 00503075.
$addhours($time,-3)
Evaluates to 19503075.
The function $RightClickMenu displays a right-click menu at the location of the last right click or at (0,0) if none has occurred. It has the following syntax:
$RightClickMenu ("ListOfMenuItems")where ListOfMenuItems is a string composed of menu item strings separated by semicolons. The menu separator is a valid menu item and is identified by one dash or minus sign “-“.
$RightClickMenu returns a string that identifies the chosen menu item or a null string if no item was chosen. The $RightClickMenu is limited to entries 31 bytes in length.
Example
$RightClickMenu ("Line 1;Line number 2;-;Another Line;Yet Another Line;")Calculates the square root of a number.
$sqrt(number)| number | a positive number or an expression that evaluates to a positive number |
Number, with the same number of decimal places as number.
$sqrt (100)
The above expression means “the square root (in base 10) of 100” and evaluates to 10.
English 
Portuguese