home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Power-Programmierung
/
CD1.mdf
/
mumps
/
appendix.doc
next >
Wrap
Text File
|
1986-08-22
|
10KB
|
231 lines
APPENDIX A
FileMan Computed Functions V.17.07
ABS Returns the absolute value of the argument.
BETWEEN A three-argument function which returns either a '0' or a '1'.
The value equals '1' if the first argument lies between the
second and the third; otherwise the returned value equals '0'.
BLANK Causes FileMan to skip 'argument' number of lines.
BREAKABLE If the argument is zero, the output device may not be
interrupted by the user (usually with a CTRL C). During
normal FileMan output, the user is allowed to interrupt the
output.
CENTER The function's argument will be centered in the page for
output. The SETTAB and TAB functions allow centering of text
and they should be the functions used with word-processing
fields.
CLOSE FileMan invokes this function to 'CLOSE' the output device.
COUNT Takes a multiple valued field (or File Name) as its argument
and returns the nunber of entries in that multiple field or
file. If the argument is a word-processing field, it returns
the number of lines in the text.
DATE Extracts the date from a Date/Time field.
DAYOFWEEK Returns the day of week (MONDAY, TUESDAY etc.) for a given
date. Returns a null value if the date is imprecise.
DOUBLE-SPACE Double spaces output of a word-processing field. This
function is normally used within word-processing "|" windows
without an argument. It may also be used as an argumented
function in response to the 'PRINT FIELD;' prompt with a
word-processing type field as its argument.
DUP Duplicates the first argument into a string 'n' characters
long, where 'n' is the second argument.
INDENT Indent the following text 'argument' number of spaces from the
left margin.
INTERNAL Returns the internally stored value of a SET, DATE or POINTER
valued field.
IOM Returns the number of column positions on the page or screen.
LAST Takes a multiple-valued field name as argument and returns the
value of the last entry in the multiple.
LOWERCASE Changes alphabetic characters to lowercase except the first
character and all characters that occur after a punctuation.
Note that a space is considered a punctuation; thus the first
character of each word will remain uppercase.
MAX Returns the greater of its two arguments.
MAXIMUM Takes a multiple-valued field as its argument and returns the
maximum value of all the entries in the multiple.
MIN Returns the lesser of its two arguments.
MINIMUM Takes a multiple-valued field as its argument and returns the
minimum value of all the entries in the multiple.
MINUTES Difference between two date/times in minutes. Returns a
negative value if the first argument is earlier than the
second. The function assumes midnight if an argument does
not contain a time.
MODULO First argument MODULO the second. This is FileMan's
implementation of the MUMPS '#' operator because the '#'
character has special meaning to FileMan.
MONTH Returns the month and year from a date-valued field.
MONTHNAME Turns "1" into "JANUARY", "2" into "FEBRUARY", etc. With
date-valued fields, use this function in conjunction with the
NUMMONTH function.
NEXT Takes a field name as its argument and returns the value that
the field has in the next entry or sub-entry. See PREVIOUS.
NOBLANKLINE Suppresses the printing of a single all-blank line if a
computed expression within word-processing "|" windows
evaluates to null.
NOW Returns the current date and time.
NOWRAP Displays a word-processing field line-for-line as originally
entered by the user. Disables 'wrap-around' if the WRAP
function was used earlier in the text.
NUMDATE Returns a date-valued field in 'MM/DD/YY' format.
NUMDAY Returns the day number (0-31) for a date-valued field.
NUMMONTH Returns the month number (0-12) for a date-valued field.
NUMYEAR Returns the year number (00-12) for a date-valued field.
PADRIGHT A two-argument function that returns the first argument with
spaces added to generate a string 'argument2' characters long.
PAGE Returns the page number of output.
PAGEFEED Start a new page whenever fewer than 'argument' number of
lines remain on the current page.
PAGESTART Start output text on line # 'argument' of the page.
PARAM Returns the value of the parameter named by the argument.
Used together with the SETPARAM function.
PREVIOUS Takes a field name as its argument and returns the value that
the field has in the previous entry or sub-entry. See NEXT.
RANGEDATE A four-argument function where the arguments are taken as two
pairs of date ranges. It returns the number of days by which
the two date ranges overlap. If the overlap is indefinite,
the function returns a zero.
REPLACE Replaces the first argument, with all occurrences of the
second argument replaced by the third. See TRANSLATE.
REVERSE Returns the argument in reverse (right to left) order.
RIGHT-JUSTIFY The text will be padded with spaces between words so that the
output will be right-justified. This function is normally
used without arguments within the "|" windows in a
word-processing field. It can also be used as an argumented
function in response to the 'PRINT BY:' prompt if the argument
is a word-processing type field.
SET Takes the value of first argument, but also puts it into the
variable named by the second argument. The variable name used
for the second argument must follow the namespacing
conventions set forth by FileMan and must be at least three
characters long. This function can be used only by a
programmer user. The SETPARAM and PARAM functions supercede
the use of this function.
SETPAGE Resets page numbering so that the following page number will
be 'argument'+1.
SETPARAM This two-argument function returns nothing but it allows
taking any field or computed expression as the first argument
and setting its value equal to an arbitrarily named parameter
(the second argument). The PARAM function can then be used
to refer to the value of this parameter.
SETTAB A multiple argument function that sets the tab stops at the
columns named by the arguments. In subsequent lines, the
first "TAB" encountered will cause indentation to column
positions 'argument1' characters from the left margin the
second "TAB" will cause indentation to column position
'argument2', and so on. In the absence of the SETTAB
function, the default tab settings are 5,10,15,20,... column
positions from the left margin.
If any SETTAB argument is negative, it means that any text
following the corresponding "TAB" will be right-justified so
that the rightmost column of that text will fall in the column
number that is the absolute value of the SETTAB argument. If
a SETTAB argument is the literal "C", the text following the
corresponding "TAB" will be centered on the page.
The "TAB 'n'" function overrides any SETTAB specification and
causes tabbing to the 'n'th column over from the left margin.
SINGLE-SPACE Output the text single-spaced. Turns off double-spacing if
the DOUBLE-SPACE function has been used previously.
SITENUMBER Returns the number identifying your site (from initialization)
SQUAREROOT Returns the squareroot of a numeric-valued argument. Returns a
null value if the argument is negative or zero.
STRIPBLANKS Deletes leading and trailing spaces from the argument.
TAB This function causes the text to start printing at the
predetermined tab settings much like what the 'TAB' key in a
typewriter does. The default tab settings are 5,10,15,20... or
they may be reset using the SETTAB function. A 'TAB' is
inserted within the text by typing the special 'TAB' key on
the keyboard, 'CTRL I' if the keyboard does not have a 'TAB'
key or by simply entering the characters "TAB" enclosed by a
pair of "|" characters. Note that when you use tha 'TAB' key
or 'CTRL I' what actually gets inserted in the text are the
characters "TAB" framed by the literal "C".
TIME Takes the time from a date.time valued field and converts it
to a twelve-hour time format with 'AM' or 'PM'.
TODAY Returns the current date.
TOP Issues a form feed to the output device.
TOTAL Takes a multiple-valued field as its argument and returns the
total of all the multiples for which there are values.
TRANSLATE Replaces, in the first argument, each occurrence of a
character in the second argument with the corresponding
character in the third argument. This is FileMan's equivalent
of the new MUMPS $TRANSLATE function. See REPLACE.
UNDERLINE Underline 'argument' if output is to a printer. The word-
processing text formatter allows underlining using the
underscore character within "|" windows ("|_|"). It will
underline the following text until another "|_|" is
encountered.
UPPERCASE Changes all alphabetic characters to uppercase.
WIDTH Specifies that the following text will always be printed out
in a column 'argument' characters wide. 'Argument', in other
words, is the difference between the left margin position and
the right margin position, plus 1. In the absence of a
'WIDTH' specification, the output column width is determined
by the user (or defaulted by the system) at "Print" time.
WRAP Causes the text to be printed in 'wrap-around' mode. Returns
to 'wrap-around' output if a NOWRAP function was previously
used.
YEAR Extracts the year from a date-valued field.