Translates data from one character set to another. Syntax $ansitodos(string) Parameters string a character string or an expression that evaluates to a character string Comments Converts the data in string from the ANSII character set to the OEM character set. See Also $DBCharSet $dostoansi About Character Literals SET DOCUMENT FORMAT
Translates data from one character set to another. Syntax $dostoansi(string) Parameters string a character string or an expression that evaluates to a character string Comments Converts the data in string from the OEM character set to the ANSII character set. See Also $ansitodos $DBCharSet SET DOCUMENT FORMAT
The current time. Syntax $time Return Value A number. Cannot be reset by an application program. Description 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.…
Read more
The error code generated by the last command executed. Syntax $errcode Return Value A number (0 to 9999.) Can be reset by an application program. Description 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…
Read more
Calculates an exponential value of the natural base (e). Syntax $exp(number) Parameters number a number or an expression that evaluates to a number Return Value Number, with the same number of decimal places as number. Example $exp(2.000) The above expression means “the natural base e, squared” and evaluates to 7.389. See Also $log $log10 $sqrt…
Read more
Returns the last Automatic Sequence Number applied. Syntax $ ZimSeqNum Return Value Number, representing an Automatic Sequence Number or $Null in case of an error. Comments 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…
Read more
Translates carriage return/line feed sequences. Syntax SET EOLNTRANSLATE string Parameters 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. Comments If the software encounters a carriage return/line feed combination in a database field when…
Read more
$addhours Calculates a time value by adding hours to (or subtracting hours from) a specified time value. Syntax $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 Return…
Read more
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…
Read more
Calculates the square root of a number. Syntax $sqrt(number) Parameters number a positive number or an expression that evaluates to a positive number Return Value Number, with the same number of decimal places as number. Example $sqrt (100) The above expression means “the square root (in base 10) of 100” and evaluates to 10. See…
Read more
English 
Portuguese