Category: Functions

Creates the named ActiveX object. Syntax $ObjCreate (ProgId) Parameters ProgId a string or an expression that evaluates to a string Return Value Returns an object that can be assigned to a variable of type object. Comments An ActiveX or COM object is identified by a GUID (a globally unique number). A ProgId identifies a COM…
Read more

Converts an expression to the date data type. Syntax $todate(expression) Parameters expression Any expression. To be meaningful, it should yield a number that has meaning in the format YYYYMMDD. Return Value Date. Example $date – $todate(19980923) In the preceding arithmetic expression, 19980923 is treated as the date 23 September 1998 instead of the number 19,980,923.…
Read more

Trims leading blanks from a character string. Syntax $ltrim(string) Parameters string a character string or an expression that evaluates to a character string Return Value Character string. Comments Use $ltrim to remove leading spaces from a character string. For output purposes, the implicit length of the result returned by $ltrim is the same as the…
Read more

Trims leading and trailing blanks from a character string in a field. Syntax $trim(string) Parameters string a character string, or any expression that evaluates to a character string Return Value Character string. Comments Use $trim to remove leading and trailing spaces from a character string in a field. For output purposes, the implicit length of…
Read more

Calculates a date value by adding days to (or subtracting days from) from a specified date value. Syntax $adddays(date,number) where date a date, or an expression that evaluates to a DATE data type number a number, or an expression that evaluates to a number Return Value Number, representing a DATE value. Comments Use $adddays to…
Read more

Calculates the arctangent of a number. Syntax $atan(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. Comments Use $atan to calculate the arctangent (in radians) of a number. The value returned by this function has the same number of…
Read more

Prints a text or bitmap file. Syntax $fileprint(filename[,filetype]) Parameters filename a character string or an expression that evaluates to a character string filetype a number that determines if the file is a text file (0) or a bitmap file (1) Return Value The $fileprint function returns “1” ($True) if no errors were detected before the…
Read more

$filepath Returns the path of the disk file associated with a specified object. Syntax $filepath(objname) Parameters objname The name of an EntitySet, relationship, application directory, or application document. Return Value The $filepath function returns a character string containing the path to the disk file that contains the specified object. AREAS.ZIM or DIRS.ZIM entries that apply…
Read more

Truncates a decimal number, making it an integer. Syntax $truncate(number) Parameters number a number, or an expression that evaluates to a number Return Value Number, with no decimal places. Example $truncate(2.49) Evaluates to 2. $truncate(2.99) Evaluates to 2. int1 – $truncate(int1/int2) * int2 Performs int1 modulo int2. Can also be expressed as $modulus(int1,int2). See Also…
Read more

Trims trailing blanks from a character string. Syntax $ttrim(string) Parameters string a character string, or any expression that evaluates to a character string Return Value Character string. Comments Use $ttrim to remove trailing spaces from a character string. For output purposes, the implicit length of the result returned by $ttrim is the same as the…
Read more