[^^Up^^] [Menu] [About The Guide]
AABOY()/AAEOY() first / last day of the year
AACURPATH() Return the full path of the current directory
AADATEFORMAT() Set the date format for internal date calculations
AADBCREATE() Create a DBF or modify a DBF structure
AAEXECUTE() Evaluate a code block, or macro a string
AAFILENAME() obtain the filename portion of a path
AAFULLPATH() concatenate a path and a filename
AAGATHER() update the current record from an array
AASCATTER() make an array from the current record
AAVG() average the elements in an array
ABREAK() turn a delimited string into an array
ACCESS() see if a file may be fopened in a mode.
ACOUNT() Count occurrences of an item in an array
AC_MENU() create a pop-up menu from an array
ADDREC() add a record to a file
ADDRESS() compose a formatted address
ADEFAULT() fill an array with blank field values
ADISPLAY() display the elements of an array in a window
AMOVE() move an array element to another position
ARRAY_DIR() ** create a sorted array of filenames
AEMPTY() find the first empty / undefined array element
AEXIST() verify existence of value in a lookup table
AFLENGTH() total string length of fields named in array
AFULL() find the last defined element in an array
AGET() GET an array element
AHEADS() Create an array of column headers
ALENGTH() find total length of a string array
ALOAD() fill an array with selected field values
AMACHINE() general-purpose state machine
AMAX() find the maximum value in an array
AMIN() find the minimum value in an array
AND() perform a logical AND on an array of logicals
APAD() Pad elements of an array to a specified length
APICS() create an array of picture statements
ARRAY_FILL() create an array-based scrolling lookup table
ASAY() Display an array element at a location
ASEEK() array-based lookup table
ASK_FOR() general-purpose user interrogation routine
ASUM() sum the elements in a numeric array
ATOS() construct a string from an array of strings
ATRANSFORM() fill an array with transformed values
AUTOSETPRN() send a code or array of codes to the printer
AVALID() array-based validation routine
BELL() ring the bell a number of times
BLANK() create a blank data value from an expression
BLINK() display a blinking message
BOM() beginning of month
BONM() beginning of next month
BOXER() draw boxes, optional box type, zoom, shadow
BOW() beginning of week
BOY() beginning of year
BROWSER() ** general-purpose browse window
CASE_OF() verify if a value is in a set of values
CENTRE() determine column at which to display a string
CFADE() fade the screen attributes in a rectangle
CHECKRANGE() force input within a specified range
CHECK_REL() verify the chain of a record's parent relations
CHG_MONS() add or subtract months from a date
CHILDREN() determine the number of child tables
CHINS() search a string for any character in a string
CHK_DBF() validate the header of a DBF file
CHK_DICT() verify an application dictionary
CHK_NTX() verify a Clipper index header
CHOOSE() menu the characters in a string
CNTRY_INFO obtain the DOS country code
CONFIGURE() utility to maintain an application system file
COUNT_EM() count records matching a condition
CRLF() add a carriage return / line feed to a string
CURDRIV() return the current drive as an ASCII numeric
DATE_KEY() assign today's date to a key for data-entry
DBEDIT_BOX()** draw a box around a DBEDIT window
DBE_SEARCH() field-sensitive DBEDIT search mechanism
DBF_EXIST() verify existence of a DBF in the current dir
DBF_NAME() append to a filename ".DBF" if absent
DBLOOKUP() scrolling lookup table using TBrowse
DB_CHECK() restrict GET input to items in a table
DB_OPEN() open a DBF with associated indexes
DB_SCROLL() create a scrolling child window
DCT_MAINT() utility to maintain the application dictionary
DDB_OPEN() ** open a table using the dictionary for data
DECLARE_EM() write source code declarations of memvars
DELETIONS() determine if any records have been deleted
DELFILES() delete a file or an array of files
DESKTOP() create a pleasant backdrop on the screen
DICTFIND() find a dictionary entry by alias or dbf name
DICTOPEN() open a table listed in the dictioanry
DOSCOLOR() determine the DOS number of a Clipper colour
DOSVERS() obtain the DOS version number as a string
DOY() obtain the numeric day of the year
DO_FV() calculate the future value of an investment
DO_IT() a generalized menu / program executor
DO_MORT() a pop-up mortgage calculator
DO_PRINC() a pop-up principal-required calculator
DO_SWAP() call a memory swapper and run another program
DRAW_BOX() generalized box-drawing routine
DSTAT() calculate descriptive statistics
DTOFN() create a file name based on a date
DUST_1() delete/recall the current record (and children)
DUST_EM() Pack a table or all open tables
ENCRYPT_IT() encrypt / decrypt a string
EOM() end of a month as a date
EOW() end of a week as a date
EOY() end of the year as a date
EPRINT() print envelopes using HPLJ printer
EXEC() execute a DOS program or drop into DOS
EXEC_RELAT() set a relational state from the dictionary
EXIST() validate input by checking a lookup table
EXPAND() double-space a string
EXTEND() calculate and display an extended price
FCALC() a pop-up financial calculator
FETCH() look up an item in a table, display a result
FIELDCOUNT() count the fields matching a name-pattern
FIELD_NO() obtain the number of a field
FILEFOUND() determine if a file exists on the path
FILES() determine the max. file handles available
FILEOPEN() try to open a DOS file using FOPEN()
FILEWRITE() write a string to a DOS file
FILL_OUT() array-based validation routine
FILTR_TYPE() determine the type of a filter
FIRSTCAP() create a proper picture statement for a field
FLDINKEY() find a field name in a string
FTOA() create an array from a field
FV() calculate the future value of an investment
GEN_PIC() an intelligent picture generator
GET_ALIAS() select a table from a dynamic menu of aliases
GET_DEVICE() create a menu which sets device to
GET_FILE() pop-up file selector
GET_FILTER() obtain the filter currently in effect if any
GET_KEYS() create an array of the current SET KEYs
GET_ORDER() obtain the index order of a key expression
GET_RELKEY() obtain the key which relates two tables
GET_STD() ** a dictionary-based GET module
GET_STD2() the standard add/edit routine for The_Usual()
GO_...() move the record pointer
GO_TO() go to or seek a record, with/without parent
HANDLCOUNT() return the number of free or used file handles
HANDLES() install a specified number of file handles
HAVING() implement a one-to-many query
HEADLINE() paint a headline box on screens or reports
HELP() context-sensitive help module
HELP_FILL() validation routine based on a lookup table
HELP_NTX() Help Index / Manager
H_MENU() create a ring menu from an array
INDEXNAMES() fill an array with names of indexes on a table
INDEX_ON() create an index
INIT_ARRAY() create, size, fill an array
INIT_QUERY() initialize the public arrays QUERY() requires
IS_ARRAY() determine if a variable is an array
IS_BTW() determine if a target lies within a range
IS_CHAR() determine if a variable is character type
IS_COLOR() determine whether to use color or mono settings
IS_DATA() determine if a keystroke pressed is a data key
IS_DATE() determine if a variable is a date
IS_DEF() determine if a variable is defined
IS_DIR() determine if a directory exists
IS_EVEN() determine if a number is odd or even
IS_FIELD() determine if a string is a fieldname
IS_FNAME() determine if a string is a valid filename
IS_IN() determine if a string is in a string or array
IS_INT() determine if a number is an integer value
IS_KEY() determine if an expression is a key expression
IS_LINKED() determine if a function has been linked in
IS_LOGIC() determine if a variable is a logical
IS_LOOKUP() see if a file is in another's lookup chain
IS_MEMO() determine if a variable is type Memo
IS_NUM() determine if a variable is type numeric
IS_ODD() determine if a number is odd
IS_OPEN() determine if a table is open
IS_PHONE() determine if a string is a valid phone number
IS_PROPER() validation routine to force proper case
IS_PROV() verify a Canadian provincial code
IS_QUERY() determine if a query has been set
IS_STATE() valiadation routine for United States
IS_TIME() verify if a string is a valid time string
IS_UNIQUE() determine if an index was created UNIQUE
IS_VIRTUAL() determine if a string is a virtual field
KCOUNT() count child records matching a condition
KEEP_RELAT() push and pop relationships for a udf
KEYFIELDS() create an array of fields used in a key
KEY_VALUE() obtain key value of a record by position
K_SCROLL() ** create a child-DBEDIT
Online resources provided by: http://www.ClipX.Net --- NG 2 HTML conversion by Dave Pearson