Determines which exponent of the natural base (e) yields a given value. Syntax $log(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 $log(7.389) The above expression means “the exponent of the natural base that yields the…
Read more
Extracts “hours” information from a standard time value. Syntax $hours(time) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT Return Value Number. Comments The system variable $Time is often used for time. Example $hours($Time) Evaluates to 23 when $Time has the value 23595999.…
Read more
Calculates the hyperbolic sine of a number. Syntax $sinh(number) Parameters number a number, or an expression that evaluates to a number, representing an angle (in radians) Return Value Number, with the same number of decimal places as number. Comments This function calculates the hyperbolic sine of a number. Example let vAngle = $sinh(3.000) Evaluates to…
Read more
Calculates the hyperbolic cosine of a number. Syntax $tanh(number) Parameters number a number, or an expression that evaluates to a number, representing an angle (in radians) Return Value Number, with the same number of decimal places as number. Comments This function calculates the hyperbolic tangent of a number. Example let vAngle = $tanh(3.000) Evaluates to…
Read more
Returns the number of the disk file associated with a specified object. Syntax $filenum(objname) Parameters objname The name of an EntitySet, relationship, application directory, or application document. Return Value For EntitySets, relationships, and application directories, $filenum returns the number associated with the file that contains the specified object. For application documents, $filenum returns the number…
Read more
Set the properties of an ActiveX object. Syntax $ObjSet[Property] (Object, PropertyName, <>) Parameters Object an object variable or formfield of type OLE PropertyName a string or an expression that evaluates to a string PropertyValue one or more strings, expressions or variables Return Value Returns a result of TRUE if successful. Comments This syntax can be…
Read more
Converts a number to a monetary format. Syntax $money(number) Parameters number a number, or an expression that evaluates to a number Return Value Number, with two decimal places. Comments Use $money to convert a number into a monetary number (i.e., with two decimal places). Number is rounded if necessary. Example $money(101.325+48.674) Evaluates to 150.00. See…
Read more
Extracts “ticks” information from a standard time value. Syntax $ticks(time) Parameters time an 8-digit number, or an expression that evaluates to an 8-digit number, expressing valid time in the form HHMMSSTT Return Value Number. Comments The system variable $Time is often used for time. With operating systems whose clocks do not support hundredths of a…
Read more
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
English 
Portuguese