Artful Two and Artful Gold Functions


Each function or module is labelled Both, Two, Gold, or Two* (the asterisk means that the function may not be used in a Gold application; it has a replacement in Gold). Functions marked with ** are backward-compatible only. They have more up-to-date replacements in Artful Two or Artful Gold.

  • Application Development Executables
  • Application Dictionary Methods
  • Array Methods
  • Array Browse Methods
  • Code Block Methods
  • Code Generation Methods
  • Commands
  • Data Dictionary
  • Database File Browse Methods
  • Database File Methods
  • Database File and Record Contention Methods
  • Database Management Meta-Methods
  • Database Relation Methods
  • Date and Time Methods
  • Dialogs
  • File and Path Methods
  • Financial Methods
  • Get/Say/Read Methods
  • Get Lookup/Validation Methods
  • Help Methods
  • Index Methods
  • Keyboard/Mouse Handling
  • Mathematical and Statistical Methods
  • Memo Methods
  • Menu Methods
  • Object Methods
  • Printer Methods
  • Program Configuration
  • Query Methods
  • Reports with List_Em()
  • Reports with Rpt_Menu()
  • Runtime Management, Evaluation and Error Control
  • Screen and Color Methods
  • String Methods
  • Text File Methods
  • Text Output Methods
  • The_Usual()
  • User Interface
  • Application Development Executables

    DCTM.EXE             Artful Two dictionary manager                      (Two*)
    DICTMAN.EXE          Artful Gold development environment                (Gold)
    WINGEN.EXE           Forms/TBrowse Designer/Code Generator              (Both)
    Back to Top

    Application Dictionary Methods

    AADICTACTIVE()       Determine if dictionary is loaded                  (Gold)
    AADICTCLOSE()        Close dictionary and all its tables                (Gold)
    CHK_DICT()           Load application dictionary                        (Both)
    DCT_MAINT()          Maintain the application dictionary                (Both)
    DELETIONS()          Determine if any records have been deleted         (Two)
    DICTCHKLVL()         Set/Get Dictionary validation level                (Both)
    DICTFIND()           Find a dictionary entry by alias or dbf name       (Two)
    DICTINDEXES()        Return array of index specs from dictionary        (Both)
    DICTOPEN()           Open a table listed in the dictioanry              (Both)
    DICTRELATIONS()      Return array of relations from dictionary          (Two)
    DICTREPORT()         Report dictionary to screen, file or printer       (Both)
    DICTSTRUCT()         Return structure of application dictionary         (Both)
    PACKDICT()           Pack/re-open/reindex all DBFs in dictionary        (Both)
    TABLESETOPEN/CLOSE() Open/close a subset of tables named in Dict        (Both)
    Back to Top

    Array Methods

    AAPPEND()            Append one array to another                        (Gold)
    AAVG()               Average elements in array                          (Both)
    ABINSCAN()           Binary search of sorted array                      (Two)
    ABROWSE()            Browse array                                       (Two)
    ABROWSEACTIVATE()    Activate array browser                             (Two)
    ABROWSENEW()         Construct array browse object                      (Two)
    ACOLUMN()            Return the nth column of 2-dim array               (Two)
    ACOUNT()             Count occurrences of item in array                 (Two)
    ADISPLAY()           Display elements of array in window                (Both)
    AEMPTY()             Find first empty/undefined array element           (Both)
    AEXIST() **          Verify existence of value in lookup table          (Both)
    AFLENGTH()           Return total string length of field values         (Two)
    AFULL()              Find last defined element in array                 (Two)
    AINITIALIZE()        Force array to known shape.                        (Two)
    AINVERT()            Invert array                                       (Two)
    ALARGEST()           Return length of longest subarray                  (Two)
    ALENGTH()            Find total length of strings in array              (Two)
    ALOAD()              Fill array with field values                       (Two)
    ALOOKUP()            Validate from array of codes and descriptions      (Two)
    AMACHINE()           General-purpose state machine                      (Two)
    AMAX()/AMIN()        Find max/min value in array                        (Both)
    AMAXSTRLEN()         Find longest string in 1-dim array                 (Two)
    AMOVE()              Move array element                                 (Two)
    AND()/OR()/NOR()     Perform logical AND, OR or NOR on array            (Both)
    APAD()               Pad elements of array to specified length          (Two)
    ARRAY2MEMO()         Create long text string from string array          (Gold)
    ARRAYMATCH()         Determine if two arrays are identical              (Two)
    ARRAYTOFILE()        Write array of strings to file                     (Gold)
    ARRAY_FILL()         Array-based scrolling lookup table                 (Two)
    ASAY() **            Display array element                              (Both)
    ASEEK()              Array-based lookup table                           (Two)
    ASUM()               Sum elements in numeric array                      (Two)
    ASWAP()              Swap two array elements                            (Two)
    ATRIM()              Trim all strings in array                          (Gold)
    AUNIQUE()            Determine if array element is unique               (Gold)
    AVALID()             Array-based validation routine                     (Two)
    CASE_OF()            Verify if value is in array of values              (Both)
    DBUNIQUE()           Return array of unique code block evaluations      (Gold)
    FILETOARRAY()        Read text file into array                          (Gold)
    FILL_OUT()           Array-based validation routine                     (Two)
    FTOA()               Return array of values of a field from DBF         (Two)
    GATHER()             Update current DBF record from an array            (Two)
    HASHEVAL()           Evaluate a code block on hash table elements       (Gold)
    HASHITEM()           Return a hash table item                           (Gold)
    HASHKILL()           Delete hash table                                  (Gold)
    HASHMAXBUCKET()      Set maximum bucket size in a hash table            (Gold)
    HASHNEW()            Create a new hash table                            (Gold)
    HASHPUTPAIR()        Insert key-item pair in hash table                 (Gold)
    HASHREMOVE()         Remove item from hash table                        (Gold)
    ISARRAYSTR()         Determine if string represents an array            (Gold)
    IS_IN()              Determine if a string is in a string or array      (Two)
    LONGEST()            Determine the longest in an array of strings       (Two)
    MEMO2ARRAY()         Read long string into array                        (Gold)
    READ_ARRAY()         Read the lines from a text file into an array      (Two)
    SCATTER()            Copy DBF field values to an array                  (Two)
    STACK*()             LIFO stack                                         (Both)
    STOA()               Return delimited portions of string in an array    (Two)
    Back to Top

    Array Browse Methods

    AARAEDIT()           Browse/edit array                                  (Gold)
    ABROWSE()            Browse array                                       (Two)
    ABROWSEACTIVATE()    Activate array browser                             (Two)
    ABROWSENEW()         Construct browse object for array                  (Two)
    ATBDISPLAY()         Frame for array-editing ABrowse()                  (Two)
    ATBEDIT()            Generalised array browse edit keyhandler           (Two)
    ATBMOVE()/ATBSORT()  Move/sort methods for ABrowse()                    (Both)
    COLORCOLUMN()        Set colour behaviour in TbColumn object.           (Both)
    Back to Top

    Code Block Methods

    AACOMPILE()          Compile string under local error control           (Gold)
    AASTRTOBLK()         Compile string under local error control           (Gold)
    ISBLOCKSTR()         Determine if string represents a code block        (Gold)
    AABLOCKEXEC()        Eval code block under local error control          (Two)
    AAEXECUTE()          Evaluate a code block or macro a string            (Both)
    COMPILEVAL()         Compile/evaluate string under error control        (Two)
    MACROBLOCK()         Convert string to code block and compile it        (Both)
    Back to Top

    Code Generation Methods

    CODESTRUCT()         Write Dbf structure function                       (Gold)
    DECLARE_EM()         Write source code declarations of memvars          (Two)
    ISARRAYSTR()         Determine if string represents an array            (Gold)
    ISBLOCKSTR()         Determine if string represents a code block        (Gold)
    ISFUNCSTR()          Determine if a string represents a function call   (Gold)
    LEMNUMAKER()         Geerate menu for The_Usual()                       (Both)
    WRITESTRUCT()        Write database structure function                  (Gold)
    Back to Top

    Commands

    @ ... LOOKUP         Command interface to DbLookup()                    (Two)
    DEFAULT...TO         Default Nil parameter to a value                   (Both)
    EDEFAULT...TO        Default empty parameter to a value                 (Both)
    EDIT                 No-frills default edit command                     (Two)
    TBROWSER             Command interface to TBrowser()                    (Both)
                         see also: Get/Read Methods
    Back to Top

    Data Dictionary (Artful Gold only)

    AADBDOMAIN()         Return Domains array for current work area         (Gold)
    AADOMBROWSE()        Data Dictionary maintenance interface              (Gold)
    DOMAINSTRU()         Return structure of data dictionary                (Both)
    Back to Top

    Database File Browse Methods

    AADBBROWSE()         Browse database file                               (Gold)
    AATBACTIVATE()       Activate tBrowse created by AaTbNew()              (Both)
    AATBDEACTIVATE()     Deactivate tBrowse created with AaTbNew()          (Both)
    AATBEXIT()/SETEXIT() Set/Execute exit trigger for tBrowse               (Both)
    AATHMETHODS()        Methods for column ins/del/swap, browse print      (Gold)
    AATBNEW()            Extended tBrowse constructor                       (Both)
    AATBOBJECT()         Return reference to AaTbActivate()'s object        (Both)
    AATBPRINT()          Print browse to text file                          (Gold)
    AUTOCOLUMNS()        Create columns for TBrowse object                  (Both)
    BROWSER() **         DbEdit() browse window                             (Both)
    COLORCOLUMN()        Set colour behaviour in TbColumn object.           (Both)
    DBE_SEARCH() **      Find/Locate from a DBEDIT() window                 (Two)
    INCRSEARCH()         Incremental search for a tBrowse                   (Two)
    K_SCROLL() **        Browse related records in a child table.           (Two)
    NEXTWIN()/PREVWIN()  Select next or previous Smart Window               (Both)
    SMARTACTIVATE()      Activate Smart Windows array                       (Two)
    SMARTCALL()          Call custom method from Smart Windows invocation   (Both)
    SMARTCHILDNEW()      Add child browse window to Smart Windows           (Two)
    SMARTEXIT()          Set exit from Smart windows system                 (Two)
    SMARTMETHODS()       Return default methods for Smart Windows           (Both)
    SMARTNEW()           Add a tBrowse window to a Smart Windows instance   (Two)
    SMARTRUN()           Run Smart Windows                                  (Both)
    SMARTSEARCH()        Relatonal Find in Smart Windows                    (Both)
    SMARTWIN()           Execute Smart Windows                              (Both)
    SMARTWINNO()         Return number of active Smart Windows window       (Two)
    TBACTIVATE() **      Activate TBrowse object made by TbNew()            (Two)
    TBADDCOLUMN()        Add a column to a TBrowse object                   (Two)
    TBADDCOLUMN()        Add column to tBrowse object                       (Two)
    TBADDWINDOW()        Add Tbrowse window to Smart Windows array          (Two)
    TBAPPEND()           Append a blank in a TBrowse window                 (Two)
    TBAPPLYKEY()         Keystroke/mouse handler for tBrowses               (Two)
    TBAUTOWIN()          TBrowse constructor for Smart Windows              (Two)
    TBCHILDACTIVATE()    Activate scoped TBrowse object made by TbNew()     (Two)
    TBCHILDNEW()         Create a Smart Windows child Tbrowse object        (Two)
    TBDEFBLOCK()         Return default block for a TbColumn                (Two)
    TBDELETE()           Delete current record in a TBrowse window          (Both)
    TBDISPLAY()          Default TBrowse frame painter                      (Two)
    TBEDITFORM()         Automatic screen for record edit under TBrowse     (Two)
    TBEXIT()             Execute exit from TBrowse()                        (Two)
    TBFRONTEND()         Demonstration front end for TBrowse()              (Two)
    TBGET()/TBGETMAN()   In-place Gets in a TBrowse window                  (Both)
    TBLOOKUP()           Scrolling lookups with edit/append                 (Two)
    TBMEDIT()            Popup memo edit for TBrowse                        (Two)
    TBNEW() **           Create TBrowse customised for in-line edit         (Both)
    TBROWAPPEND()        Append and edit in TBrowse made with TbNew()       (Two)
    TBROWEDIT()          In-line edit in TBrowse made with TbNew()          (Two)
    TBROWSE()            Extended TBrowse instance                          (Two)
    TBROWSER()           Generalised TBrowse window for The_Usual()         (Both)
    TBROWSERRESULT()     Return detailed info from TBrowser() call          (Both)
    TBSWAPCOLUMNS()      Swap 2 columns in a TBrowse instance               (Two)
    TBWINNEW()           Create a new Smart Window                          (Two)
    TB_SEARCH()          Incremental search for tBrowse window              (Both)
    USERBROWSE()         Select/open/browse Dbfs                            (Gold)
    VUBROWSEACTIVATE()   Activate Full-Screen TBrowse                       (Two)
    VUBROWSENEW()        Full-Screen TBrowse                                (Two)
    WREFRESHALL()        Refresh all windows in Smart Windows               (Two)
    Back to Top

    Database File Methods

    AACLOSEALL()         Close all work areas, update aDbInfo[]             (Both)
    AACDXAXS()           Return methods array for Advantage SixCdx driver   (Gold)
    AACLOSEAREA()        Close current work area, update aDbInfo[]          (Both)
    AACOPY()             Copy database file                                 (Both)
    AADBALIAS()          Return alias of database filename                  (Gold)
    AADBAPPEND()         Append from database file to another               (Both)
    AADBBROWSE()         Browse database file                               (Gold)
    AADBCNVDIALOG()      RDD-conversion dialog box                          (Gold)
    AADBCONVERT()        Convert database file to another RDD format        (Gold)
    AADBCREATE()         Create/update database file structure              (Both)
    AADBDELETE()         Delete current record, update aDbInfo[]            (Gold)
    AADBDOMAIN()         Return Domains array for current work area         (Gold)
    AADBFCDX()           Return methods array for DbfCdx driver             (Gold)
    AADBFCMX()           Return methods array for Comix driver              (Gold)
    AADBFILENAME()       Return database file name                          (Both)
    AADBFILEXT()         Return database file extent for a driver           (Gold)
    AADBFIND()           Search/Locate dialog box                           (Gold)
    AADBFLEN/POS/REC()   Index length and position                          (Both)
    AADBFMDX()           Return array of DbfMdx methods                     (Gold)
    AADBFNAME()          Default database filename extent                   (Gold)
    AADBFNTX()           Return array of DbfNtx methods                     (Gold)
    AADBFOPEN()          Open database file with DbfNtx driver              (Both)
    AADBFSIX()           Return array of DbfSix driver methods              (Gold)
    AADBINFO()           Return aDbInfo array for current work area         (Both)
    AADBMATCH()          Determine equivalence of file structures           (Gold)
    AADBMETHODS()        Set/Get methods for database driver                (Gold)
    AADBOPEN()           Open database file                                 (Gold)
    AADBPACK()           Pack a database file                               (Gold)
    AADBRELATIONS()      Return relations for work area from aDbInfo[]      (Gold)
    AADBREOPEN()         Reopen database file using aDbInfo[]               (Gold)
    AADBSTRUCT()         Return structure of database file                  (Both)
    AADBUSE()            Execute DbUseArea() under local error control      (Both)
    AADBUSEAREA()        Open database file, post to aDbInfo[]              (Gold)
    AADBVERIFY()         Verify header integrity of database file           (Gold)
    AADELETE()           Record deletion dialog box                         (Gold)
    AAIMPORTDB()         Formula-driven import from one Dbf into another    (Gold)
    AAIMPORTSDF()        Import data to a Dbf from an Sdf text file         (Gold)
    AANTXAXS()           Return methods array for Advantage DbfNtx driver   (Gold)
    AAPROJECT()          Copy unique set of records to another Dbf          (Gold)
    AARECCOPY()          Record array with fields filled from other table   (Gold)
    AASCOPE...()         Scoped record movement                             (Two)
    AASCOPEDIALOG()      Dialog box to set scope                            (Gold)
    AASELECTAREA()       Select work area, return previous                  (Gold)
    AASETEXCLUSIVE()     Artful Gold Exclusive setting                      (Gold)
    AATABLES()           Return aDbInfo[] for all tables                    (Gold)
    ACHILDRECS()         Return array of child records                      (Two)
    ACHILDREN()          Return array of child tables from Dictionary       (Both)
    ACOMPATRDDS()        Return array of RDDs compatible with data file     (Gold)
    ADDREC()             Add record to file                                 (Two)
    AFLENGTH()           Return total string length of field values         (Two)
    ARECPERMIT/RELEASE() Obtain/remove record locks on multiple tables      (Two)
    AUTOMAINT()          Vanilla file maintenance window                    (Gold)
    CHK_DBF()            Validate the header of DBF file                    (Two*)
    COUNT_EM()           Count records matching condition, pop up result    (Both)
    DBF/NTX_NAME()       Default file extent to ".DBF" or ".NTX"            (Both)
    DBFFIELDS()          Return array of field names from current Alias     (Both)
    DBFILERDD()          Determine driver for database file                 (Gold)
    DBFIRSTBYTE()        Return first byte of a database file               (Gold)
    DBF_EXIST()          Verify existence of a DBF in the current dir       (Both)
    DBGETSTRUCT()        Return structure of a Dbf                          (Gold)
    DBUNIQUE()           Return array of unique code block evaluations      (Gold)
    DB_OPEN()            Open a DBF with associated indexes                 (Both)
    DETAILRECS()         Execute code block on all child records            (Gold)
    DUST_1()             Delete/recall current record (and children)        (Two)
    DUST_EM()            Pack a table or all open tables                    (Two)
    EXPORT()             Export Data to Dbfs or Text Files                  (Both)
    FIELDCOUNT()         Count the fields matching a name-pattern           (Two)
    FLDINKEY()           Find a field name in a string                      (Two)
    FTOA()               Return array of values of a field from DBF         (Two)
    GATHER()             Update current DBF record from an array            (Two)
    GET_ALIAS()          Select a table from a dynamic menu of aliases      (Both)
    GO_*()               Record movement under The_Usual()                  (Both)
    GO_TO()              Go to or seek a record, with/without parent        (Both)
    HEADER()             Create a cosmetic rendition of a field name        (Two)
    IMPORTDLG()          Dbf-import dialog                                  (Gold)
    ISDBFCDX()           Determine if the DbfCdx driver is linked in        (Gold)
    ISDBFMDX()           Determine if the DbfMdx driver is linked in        (Gold)
    ISDBFNTX()           Determine if the DbfNtx driver is linked in        (Both)
    ISDBFSIX()           Determine if the DbfSix driver is linked in        (Gold)
    ISRDDCOMPAT()        Determine compatibility of file with driver        (Gold)
    IS_FIELD()           Determine if a string is a fieldname               (Both)
    IS_OPEN()            Determine if a table is open                       (Both)
    KEY_VALUE()          Obtain key value of a record by position           (Both)
    K_SCROLL() **        Browse related records in a child table.           (Two)
    MAKE_TABLE() **      Create a DBF from arrays of field names/specs      (Two*)
    MENU_REC()           Point-and-shoot record selector                    (Two)
    MODI_STRU()          Interactively create / modify a DBF structure      (Both)
    MUSE() **            Open a DBF in a multi-user environment             (Two*)
    MZAP()               Zap a DBF in a multi-user environment              (Two)
    NEXTRPL()            Next() a field, then call Rpl()                    (Gold)
    PACKFILE()           Remove all deleted records from .dbf/.dbt          (Both)
    PROJECTDLG()         Front-end dialog for AaProject()                   (Gold)
    RBLANK()             Blank all fields in DBF record                     (Two)
    RCOPY()              Copy one record into another                       (Two)
    REPLACE_EM()         Single/multiuser cover for REPLACE                 (Two)
    RPL()                Generalised replace module                         (Two)
    RPLCHIFLDS()         REPLACE non-key fields in child tables             (Two)
    RPLFIELDS()          Multi-file replace routine                         (Two)
    RRPL()               Update redundant fields in related child records   (Two)
    SHOWSTRUCT()         Write database file structure description          (Two)
    SHOWTABLES()         Display aDbInfo[] array for all open tables        (Both)
    STRUCTJOIN()         Merge two database file structures                 (Gold)
    STRUCTMATCH()        Determine if two database file structures match    (Gold)
    SUM_FIELDS()         Sum numeric fields in a table                      (Two)
    TAGFIELDS()          Field-tagging popup window                         (Two)
    TAG_RECORD()         Hot-key access to record tagging                   (Two)
    TRANSFER()           Copy or move data from one table to another        (Two)
    UNIQUE()             Prevent duplicate records in a table               (Both)
    Back to Top

    Database File and Record Contention Methods

    ADDREC()             Add record to file                                 (Two)
    APPENDHOLD()         Prevent other users from appending                 (Gold)
    ARECPERMIT/RELEASE() Obtain/remove record locks on multiple tables      (Two)
    FILEPERMIT/RELEASE() Lock/unlock a file                                 (Two)
    LOCKFILE()           Attempt to lock a file, with retry                 (Two)
    LOCKREC()            Attempt to lock a record, with retry               (Two)
    LOCKREL()            Attempt to lock the record and related tables      (Two)
    RECPERMIT()          Record write permission                            (Two)
    RECRELEASE()         Unlock record                                      (Two)
    ULOCKLATE()          Toggle late relational locking under UGet()        (Gold)
    UNLOCKREL()          Unlock current record and related records          (Two)
    Back to Top

    Database Management Meta-Methods

    AUTOMAINT()          Vanilla file maintenance window                    (Gold)
    DB_SCROLL()          Create a scrolling child window                    (Two)
    DICTFMAINT()         Execute function named in DICT->Udf_Maint          (Gold)
    EDIT                 No-frills default edit command                     (Two)
    EDITFORM()           Default popup edit form                            (Two)
    EXPORT()             Export Data to Dbfs or Text Files                  (Both)
    K_SCROLL() **        Browse related records in a child table.           (Two)
    QUITPROG()           Close up and exit a program                        (Both)
    RECEDIT()            Execute an edit form as a popup                    (Both)
    SETUP()              Set up program environment including F setting     (Two)
    SHOWTABLES()         Display aDbInfo[] array for all open tables        (Both)
    SMARTRUN()           Run Smart Windows                                  (Both)
    SMARTWIN()           Execute Smart Windows                              (Both)
    TBFRONTEND()         Demonstration front end for TBrowse()              (Two)
    THE_USUAL()          File maintenance meta-function                     (Two)
    VUBROWSEACTIVATE()   Activate Full-Screen TBrowse                       (Two)
    VUBROWSENEW()        Full-Screen TBrowse                                (Two)
    Back to Top

    Database Relation Methods

    AAPARENTKEY()        Return key relating a table to its parent          (Gold)
    AARELEXEC()          Set relations for table, execute code block        (Gold)
    AARELFIND()          Relational Find                                    (Both)
    ACHILDRECS()         Return array of child records                      (Two)
    ACHILDREN()          Return array of child tables from Dictionary       (Both)
    APARENTS()           Return array of parent tables from Dictionary      (Both)
    ARELATIONS()         Return array of all current relations              (Two)
    DB_SCROLL()          Create a scrolling child window                    (Two)
    DETAILRECS()         Execute code block on all child records            (Gold)
    DICTRELATIONS()      Return array of relations from dictionary          (Two*)
    GETRELKEY()          Return key relating two tables                     (Two)
    INITPARENTKEYS()     Initialise parent key fields in record array       (Both)
    ISCHILD()            Determine if there is a parent-child relation      (Both)
    ISPARENT()           Determine if there is a child-parent relation      (Both)
    IS_LOOKUP()          See if a file is in another's lookup chain         (Both)
    KCOUNT()             Count child records matching a condition           (Two)
    KEEP_RELAT()         Push and pop relationships for a udf               (Both)
    PUSH/POP_REL()       Push/pop a dictionary-driven relational state      (Both)
    RPL()                Generalised relational replace module              (Two)
    RPLCHIFLDS()         Replace non-key fields in child tables             (Two)
    RPLFIELDS()          Multi-table replace routine                        (Two)
    RRPL()               Update redundant fields in related child records   (Two)
    SETRELATIONS()       Set relations specified in an array                (Two)
    SET_RELAT()          Set all relations specified in a DICT record       (Both)
    SET_TABLE()          Default menu interface for THE_USUAL()             (Both)
    UNLOCKREL()          Unlock current record and related records          (Two)
    UNSETRELS()          Set all current relations off                      (Two)
    Back to Top

    Date and Time Methods

    AADATEFORMAT()       Set date format                                    (Both)
    ADDMONTHS()          Increment/decrement date                           (Two)
    BOM()                Beginning of month                                 (Two)
    BONM()               Beginning of next month                            (Two)
    BOW()                Beginning of week                                  (Two)
    BOY()/EOY()          First or last day of year                          (Both)
    CALENDAR()           Pop-up calendar                                    (Two)
    DATEBOOK()           Scrolling datebook with popup calendar             (Two)
    DATE_KEY()           Assign today's date to key                         (Two)
    DAYSINMO()           Return number of days in month                     (Two)
    EOM()                Return end of a month as a date                    (Two)
    EOW()                End of a week as a date                            (Two)
    IS_LEAP()            Determine if year of date is a leap year           (Two)
    IS_TIME()            Verify if a string is a valid time string          (Both)
    MONS_BTW()           Obtain the number of months between 2 dates        (Two)
    STD_DATE()           Generalised date manipulation function             (Two)
    STOD()               (yy)yymmdd string --> date                         (Gold)
    TDIFF()              Calculate the difference between two times         (Two)
    TEXTDATE()           Transform a date to a text string                  (Two)
    TEXTTIME()           Display time in a specified formats                (Two)
    TTOS()               Convert a time to number of seconds                (Both)
    YEARS_BTW()          Calculate the years between two dates              (Two)
    Back to Top

    Dialogs

    AADIALOG()           Dialog box with buttons                            (Gold)
    AAERRORDLG()         Dialog box with red "Error" header                 (Both)
    AALOCATE()           Unindexed search dialog box                        (Gold)
    AASCOPEDIALOG()      Dialog box to set scope                            (Gold)
    AAWARNDLG()          Dialog box with red "Warning" header               (Both)
    ASK_FOR()            Pop-up Get                                         (Two)
    CHOOSE()             Menu characters in string                          (Two)
    DOSUTIL()            DOS Utility Popup Window                           (Both)
    EXPORT()             Export Data to Dbfs or Text Files                  (Both)
    FILEPRNDLG()         Print-file dialog                                  (Gold)
    GETFILE()            single-file combo box                              (Both)
    GETFILES()           Multi-file selection dialog                        (Gold)
    GET_ALIAS()          Select a table from a dynamic menu of aliases      (Both)
    IMPORTDLG()          Dbf-import dialog                                  (Gold)
    LOGIN()              Generalised logIn procedure with password          (Two)
    MASK_FOR()           Popup search-target requestor with formatting      (Two)
    MENU_ORD()           Allow changing of order via pulldown menu          (Both)
    MENU_REC()           Point-and-shoot record selector                    (Two)
    PASSWORD()           Get and validate a user password                   (Two)
    POP_MSG()            Pop up a message, wait for a keystroke             (Two)
    RECEDIT()            Execute an edit form as a popup                    (Both)
    RUN_DIR()            Show a sorted directory in a scrolling window      (Two)
    SCROLLFILE()         Scroll/pan/print a text file in a window           (Both)
    SEARCH()             Search with index-selection pulldown               (Both)
    SEEK_REL()           Relation-sensitive SEEK command                    (Both)
    SHOWDIR()            Display disk directory                             (Two)
    TAGFIELDS()          Field-tagging popup window                         (Two)
    TAG_RECORD()         Hot-key access to record tagging                   (Two)
    T_MENU()             Multiple-choice pop-up tag menu                    (Both)
    USERBROWSE()         Select/open/browse Dbfs                            (Gold)
    VERIFY()             Verify dialog box                                  (Both)
    YESNO()              Pop-Up box to get Yes, No, or Cancel               (Two)
    Back to Top

    DOS Access

    DOSVERS()            Obtain the DOS version number as a string          (Two)
    PRN_STATUS()         Determine printer status                           (Two)
                         see also: File and Path methods
    Back to Top

    File and Path Methods

    AACURPATH()          Return full path of current directory              (Both)
    AAFILENAME()         Obtain filename portion of path                    (Two)
    AAFILEVIEW()         View text file in moused window                    (Gold)
    AAFULLPATH()         Concatenate path and filename                      (Two)
    AAPATHNAME()         Return path portion of filename                    (Two)
    ACCESS()             Determine if file may be fOpened in a mode         (Two)
    ARRAYTOFILE()        Write array of strings to file                     (Gold)
    ARRAY_DIR() **       Create sorted array of filenames                   (Two)
    CHDIR()              Change Directory                                   (Two)
    CURDRIV()            Return current drive as Ascii numeric              (Two)
    CURDRIVE()           Return current drive as Ascii string               (Two)
    DELFILES()           Delete a file or an array of files                 (Two)
    DOSUTIL()            DOS Utility Popup Window                           (Both)
    DTOFN()              Create a file name based on a date                 (Two)
    FILEFOUND()          Determine if a file exists on the path             (Two)
    FILEOPEN()           Try to open a DOS file using FOPEN()               (Two)
    GETFILE()            Popup file selector                                (Both)
    GETFILES()           Multi-file selection dialog                        (Gold)
    IS_DIR()             Determine if a directory exists                    (Two)
    IS_DRIVE()           Determine if a drive is on-line                    (Two)
    IS_FNAME()           Determine if a string is a valid filename          (Two)
    MKDIR()              Create a directory                                 (Two)
    PATHFIND()           Find a file in the current DOS path                (Two)
    PATHVALIDATE()       Validate a full path name                          (Two)
    RMDIR()              Remove a directory                                 (Two)
    ROOTNAME()           Return filename shorn of file extension            (Two)
    RUN_DIR()            Show a sorted directory in a scrolling window      (Two)
    SCRAPFILES()         Manage temporary files                             (Two)
    SCROLLFILE()         Scroll/pan a text file in a window                 (Two)
    SETDRIVE()           Set the current drive                              (Two)
    SHOWDIR()            Display disk directory                             (Two)
    TEMPNAME()           Create a uniquely named temporary file             (Two)
    TTOFN() **           Establish a file name based on the time            (Both)
    Back to Top

    Financial Methods

    DOLLARSTR()          Return dollars & cents amount as words             (Gold)
    DOY()/WOY()          Obtain the numeric day or week of the year         (Both)
    DO_FV()              Calculate future value of an investment            (Two)
    DO_MORT()            Pop-up mortgage calculator                         (Two)
    DO_PRINC()           Pop-up principal-required calculator               (Two)
    FCALC()              A pop-up financial calculator                      (Two)
    FV()                 Calculate future value of an investment            (Two)
    PMT()                Calculate mortgage payment on a loan               (Two)
    Back to Top

    Get/Say/Read Methods

    AAGATHER()           Update current DBF record from an array            (Two)
    AAGETLIST()          Post active getList for external reference         (Two)
    AAGETMODE()          Return Get mode from UGet() or Get_Std2()          (Two)
    AAGETPOS()           Return current Get position                        (Two)
    AAISNEWEDIT()        FLag indicating new edit under UGet()              (Gold)
    AASCATTER()          Return named field values in array                 (Two)
    AASETCTRL()          Set/Get taking Ctrl chars as data in Get           (Both)
    AASETKEYLOOKUP()     Set/Get postBlock-activation hot key               (Gold)
    AASETLOOKUP()        Was postBlock-activation key pressed?              (Gold)
    AASETRBUTT()         Set/Get whether right mouse button exits Read      (Both)
    AASETREAD()          Set/Get Read code block for Read_It()              (Both)
    ABLANK()             Return array of blank field values for work area   (Two)
    AGET() **            GET array element                                  (Two)
    APICTURES()          Return array of picture statements for fields      (Both)
    ARRAYEDIT            Array-edit Get reader                              (Gold)
    ASAY() **            Display array element                              (Two)
    BLANK()              Return blank field value                           (Two)
    BUTTON...AT          Push Button Control                                (Both)
    CHECKBOX             CheckBox Get                                       (Two)
    DATE_KEY()           Assign today's date to key                         (Two)
    FIRSTCAP()           Create a proper picture statement for a field      (Both)
    GATHER()             Update current DBF record from an array            (Two)
    GEN_PIC()            Intelligent picture generator                      (Two)
    GET...APICKLIST()    Get Picklist command                               (Both)
    GET...BOX            Boxed Get                                          (Both)
    GET...DATE           Edit date with cursor keys in a Get                (Both)
    GET...DROPFIELD      Dropfield Get                                      (Both)
    GET...HELP           Get with field-specific help                       (Both)
    GET...MEMO           Popup memo edit window                             (Both)
    GET...SHADOW         Shadowed Get                                       (Both)
    GET_STD2() **        Get/Read administrator for The_Usual()             (Two*)
    ISAPPEND()           Is UGet() or Get_Std2() is in append mode?         (Two)
    IS_FIELD()           Determine if a string is a fieldname               (Both)
    RADIO...BUTTONS      Radio button Get                                   (Both)
    READKEY()            Resolve ReadKey() and Clipper's LASTKEY()          (Two)
    READ_IT()            Single udf to handle all READs                     (Two)
    SCATTER()            Copy DBF field values to an array                  (Two)
    UGETMESSAGE()        Set/Get save prompts for Add/Edit in UGet()        (Gold)
    UGETPERMIT()         Set/Get edit-permission code block                 (GOld)
    ULOCKLATE()          Set/Get late record locking                        (Gold)
    USERPAGESET()        Set current UGet() active page in multi-page form  (Gold)
    USETCHILDRECLOCKS()  Set/Get multi-record child locking in U_RecEdit()  (Gold)
    USETSHOWBLANK()      Set/Get showing EoF() records in The_Usual()       (Gold)
    Back to Top

    Get Lookup/Validation Methods

    ARRAY_FILL()         Array-based scrolling lookup table                 (Two)
    ASEEK()              Array-based lookup table                           (Two)
    AVALID()             Array-based validation routine                     (Two)
    CHECKRANGE()         Force input within specified range                 (Two)
    CHOOSE()             Menu characters in string                          (Two)
    DBLOOKUP()           Scrolling lookup table using TBrowse               (Two)
    DBUNIQUE()           Return array of unique code block evaluations      (Gold)
    DB_CHECK()           Restrict GET input to items in a table             (Two)
    EXIST()              Verify existence of value in a lookup table        (Two)
    EXTEND()             Calculate and display an extended price            (Two)
    FETCH()              Look up an item in a table, display a result       (Two)
    FILL_OUT()           Array-based validation routine                     (Two)
    HELP_FILL()          Validation routine based on a lookup table         (Both)
    INITPARENTKEYS()     Initialise parent key fields in record array       (Both)
    IS_PHONE()           Determine if a string is a valid phone number      (Two)
    IS_PROPER()          Validation routine to force proper case            (Two)
    IS_PROV()            Verify a Canadian provincial code                  (Two)
    IS_STATE()           Validation routine for U.S states                  (Two)
    LOOKUP()             Scrolling lookup table using TBrowse               (Two)
    MINIMAX()            Force a value within a specified range             (Two)
    NEXT()               Create next item for a sequential index            (Both)
    PARENTLOOKUP()       Lookup value in parent table, browse if not found  (Gold)
    TBLOOKUP()           Scrolling lookups with edit/append                 (Two)
    UNIQUE()             Prevent duplicate records in a table               (Both)
    WINLOOK.ATM          WinGen lookup browser template                     (Gold)
    WINLUKUP.ATM         Ditto with add/edit capability                     (Gold)
    Back to Top

    Help Methods

    AAHELPPUSH/POP       F1-setting stack                                   (Two)
    GET...HELP           Get with field-specific help                       (Both)
    HELP()               Context-sensitive help module                      (Both)
    HELPCODE()           Set or retrieve current Help Code                  (Two)
    HELPFIND()           Find help topic in Help Table                      (Both)
    HELPVAR()            Set/Get Help Id associated with a Get object       (Two)
    HELP_NTX()           Help Manager                                       (Two)
    Back to Top

    Index Methods

    AACLEARINDEX()       Close all indexes in work area, update aDbInfo[]   (Gold)
    AACREATEINDEX()      Create index, update aDbInfo[]                     (Gold)
    AADBFLEN/POS/REC()   Index length and position                          (Both)
    AAGETORDER()         Return current index order                         (Gold)
    AAINDEXEXT()         Return index file extent for driver                (Gold)
    AAINDEXFNAME()       Return index file name for order                   (Gold)
    AAINDEXKEY()         Return index key for order                         (Gold)
    AAINDEXNAMES()       Return array of index names                        (Gold)
    AAINDMAKE()          Create index from index spec array                 (Gold)
    AAINDNAME()          Create automatic index name                        (Gold)
    AAINDNEW()           Return blank index spec array                      (Gold)
    AAINDVERIFY()        Determine concurrency of index tag                 (Gold)
    AAORDBAGINDEXES()    Return index spec arrays from aDbInfo[]            (Gold)
    AASETGAUGE()         Toggle indexing gauge                              (Gold)
    AASETINDEX()         Set index, update aDbInfo[]                        (Gold)
    AASETORDBAGS()       Set all indexes in ARTFUL GOLD index spec array    (Gold)
    AASETORDER()         Execute order-setting method in current work area  (Gold)
    AASIXPACK()          Pack DbfSix database file                          (Gold)
    CHK_NTX()            Verify Clipper DbfNtx index                        (Two*)
    FLDINKEY()           Find a field name in a string                      (Two)
    GET/SETORDER()       Return/set index order of a key expression         (Both)
    INCRSEARCH()         Incremental search for a tBrowse                   (Two)
    INDEXCOUNT()         Return no. if active index tags in work area       (Gold)
    INDEXCUES()          Return array of index menu prompts                 (Both)
    INDEXKEYS()          Return array of active index keys                  (Both)
    INDEXNAMES()         Fill array with names of indexes on a table        (Both)
    INDEXPICS()          Return pictures for fields in a key                (Gold)
    INDEX_ON()           Create an index                                    (Two*)
    ISPRIMARYKEY()       Determine if an index key is primary               (Gold)
    IS_KEY()             Determine if an expression is a key expression     (Two)
    IS_UNIQUE()          Determine if an index was created UNIQUE           (Both)
    KEYFIELDS()          Create an array of fields used in a key            (Two)
    KEY_VALUE()          Obtain key value of a record by position           (Both)
    MASK_FOR()           Popup search-target requestor with formatting      (Two)
    MENU_ORD()           Allow changing of order via pulldown menu          (Both)
    MULTIPIC()           Return string of pictures for multi-field key      (Both)
    NOFINDMESG()         General pop-up message for failed seeks            (Two)
    NTXKEY()             Return key from .NTX file                          (Two)
    SEARCH()             Search with index-selection pulldown               (Both)
    SEEK_REL()           Relation-sensitive SEEK command                    (Both)
    SET_INDEX()          General purpose set-index function                 (Two)
    SMARTSEARCH()        Relatonal Find in Smart Windows                    (Both)
    XCOUNT() **          Count open index in work area                      (Both)
    XDECR()              Return the previous possible index key value.      (Gold)
    XINCR()              Return next logical index key value                (Both)
    Back to Top

    Keyboard/Mouse Handling

    AA...KEY()           InKey() customization                              (Both)
    AAINKEY()            Mouse-installable InKey() replacement              (Two)
    AASETGETKEY()        Set/Get block to poll keyboard and mouse           (Two)
    AASETINKEY()         Set/Get InKey() replacement                        (Two)
    IS_DATA()            Determine if a keystroke pressed is a data key     (Both)
    KBDBUFF()            Stuff/Retrieve string of keyboard chars            (Gold)
    KEYDEFAULTS()        Set key defaults for Set_Keys()                    (Two)
    SLEEP()              Pause for a specified number of seconds            (Two)
    Back to Top

    Mathematical and Statistical Methods

    AAVG()               Average elements in array                          (Both)
    ASUM()               Sum elements in numeric array                      (Two)
    DSTAT()              Calculate descriptive statistics on a table        (Two)
    IS_BTW()             Determine if a target lies within a range          (Both)
    IS_EVEN()/IS_ODD()   Determine if a number is even or odd               (Both)
    IS_INT()             Determine if a number is an integer value          (Both)
    MINIMAX()            Force a value within a specified range             (Two)
    MOD()                Determine the modulus of a number                  (Both)
    MOD_10()             Perform a mod 10 check on an integer               (Two)
    RUNNINGAVG()         Maintain a running average                         (Gold)
    RUNNINGSUM()         Maintain a running sum                             (Gold)
    Back to Top

    Memo Methods

    AAMEMOEXT()          Return memo file extent for driver                 (Gold)
    AAMEMOFILENAME()     Return full name of memo file                      (Gold)
    AAMEMOWRITE()        Write long string to text file                     (Gold)
    AANOTEPAD()          Popup text editor                                  (Gold)
    AMEMOWRAP()          Return array of wrapped text lines                 (Gold)
    ARRAY2MEMO()         Create long text string from string array          (Gold)
    MCOUNT() **          Determine the number of memo fields in a DBF       (Both)
    MEMO2ARRAY()         Read long string into array                        (Gold)
    MEMOFIELDS()         Create an array of names of memo fields            (Two)
    MEMOGET()            Popup memo editor                                  (Two)
    MEMOPOS()            Return the field number of a memo field            (Two)
    MEMOSTATUS()         Determine if memo field is full                    (Two)
    NOTEPAD()            Generalised NotePad to link into an app            (Two)
    PRESENT()            Display text in a window                           (Two)
    READER()             Read a text file into a memo field                 (Both)
    READ_MEMO()          Popup window to edit a memo or any text            (Both)
    RUN_WP()             Edit a memo field with a word processor            (Two)
    WRITER()             Write a memo field out to an ASCII file            (Two)
    Back to Top

    Menu Methods

    AC_MENU()            Pop-up menu                                        (Two)
    BUILDMENU()          Build pulldown menu from DPD v2.0 .MNU file        (Two)
    DEVELUTIL()          Developer's utility menu                           (Both)
    DO_IT()              Generalised menu / program executor                (Two)
    H_MENU()             Create a ring menu from an array                   (Two)
    L_MENU()             Generalised ring menu administrator                (Both)
    MAKE_MENU()          Default menu builder Udf for The_Usual()           (Both)
    MENUPOPUP()          Popup menu centred on screen                       (Two)
    PBMENUACTIVATE()     Activate a pushbutton menu                         (Two)
    PBMENUDEACTIVATE()   Deactivate a pushbutton menu                       (Two)
    PBMENUNEW()          Create a pushbutton menu.                          (Two)
    PBMENUSHOW()         Display a pushbutton menu                          (Two)
    PBUTTONADD()         Add button to a pushbutton menu.                   (Two)
    PBUTTONNEW()         Create a pushbutton.                               (Two)
    PDACTIVATE()         Activate a DPD v2.0 pulldown menu system           (Two)
    PDM()                Execute menu created by DPD v3.0                   (Both)
    PD_ADDMENU()         Add a child pulldown to a parent pulldown.         (Two)
    PD_BECOME()          Assemble array of menus for PD_MENU()              (Two)
    PD_CREATE()          Create menu for use by PD_MENU()                   (Two)
    PD_MENU()            Pulldown menu system using OMenu.Prg               (Two)
    PULL_OPEN()          Pull down a submenu from THE_USUAL()               (Both)
    T_MENU()             Multiple-choice pop-up tag menu                    (Both)
    V_MENU()             Generalised vertical menu/executor                 (Two)
    Back to Top

    Object Methods

    CARGO*()             Cargo suite for Clipper objects                    (Both)
    IS_OBJECT()          Determine if item is an object                     (Two)
    Back to Top

    Printer Methods

    AASETPRINTER()       Set printer ID for Printer Table codes             (Gold)
    AUTOSETPRN()         Send code or array of codes to printer             (Both)
    EPRINT()             Print envelopes using HPLJ printer                 (Two)
    FILEPRNDLG()         File-print dialog                                  (Gold)
    HP_*()               HP LaserJet control suite                          (Both)
    OUT_OK()             Check if ESC was pressed during a report           (Two)
    PRINTER()            Return printer status, popup problem messages      (Both)
    PRN_CODE()           Send Printer Tablecode to the printer or return it (Both)
    PRN_STATUS()         Get printer status                                 (Both)
    SEND_CODE()          Send Printer Table control string(s) to printer    (Both)
    SETPRNBLOCK()        Set routine to select a printer                    (Gold)
    SET_PRN()            Data-driven printer-setup routine                  (Both)
    Back to Top

    Program Configuration

    AACFGITEM()          Retrieve configuration item                        (Gold)
    AACFGSET()           Post contents of program configuration file        (Gold)
    AACONFIGURE()        Maintain Sys Table                                 (Both)
    Back to Top

    Query Methods

    FILTR_TYPE()         Determine the type of a filter                     (Both)
    GET_FILTER()         Return query in effect in current work area        (Both)
    HAVING()             One-to-many query                                  (Both)
    IS_QUERY()           Determine if a query has been set                  (Both)
    NOTHAVING()          Negative one-to-many query                         (Both)
    ONETOMANY()          Determine if a one-to-many query is in effect      (Both)
    OPT*()               Return info on optimised query                     (Both)
    PUSH/POP_QUERY()     Push/pop query state                               (Both)
    QUERIES()            Maintain Saved Queries table                       (Two)
    QUERY()              Point-and-shoot query module                       (Two)
    QUERYNAME()          Return name of current query                       (Two)
    Q_OPTIMIZE()         Set or undo an optimised filter.                   (Both)
    SET_FILTER()         Set a normal or optimised filter                   (Both)
    U_QUERY()            The_Usual()'s interface with Query()               (Both)
    Back to Top

    Reports with List_Em()

    AALISTSCOPESET()     Set scope for List_Em() report                     (Gold)
    AAPAGEFTR()          Default page footer for a List_Em() report         (Gold)
    AAPAGELINES()        Get/Set current page line count                    (Both)
    AAPAGENEW()          Zero page line and record count                    (Both)
    AAPAGERECS()         Get/Set page item count                            (Both)
    AASETMARGIN()        Set left margin                                    (Gold)
    AASETPGFTR/HDR()     Set header/footer for List_Em() report             (Gold)
    AATARGET()           Return destination of List_Em() report             (Both)
    AAWIDTH()            Return width of List_Em() report                   (Both)
    LINEOUT()            Write line or array of lines in a report           (Both)
    LINE_CTRL()          Page break control in List_em() report             (Both)
    LIST_EM()            Line-oriented, coded reports                       (Both)
    MACRO_RPT()          Execute a report as a macro-expansion              (Both)
    SET_TARGET()         Select output destination for LIST_EM() report     (Both)
    Back to Top

    Reports with Rpt_Menu()

    AAJOBCREATE()        Create job file for report under The_Usual()       (Gold)
    AARPTMENU()          Report menu for The_Usual()                        (Gold)
    GET_DEVICE()         Create a menu which sets device to                 (Two)
    REPO_MAN()           Reports Table manager                              (Both)
    RPTCONVERT()         Convert Reports Table to new format                (Gold)
    RPTEXEC()            Execute report documented in report job file       (Gold)
    RPTGETLIST()         Return array of reports from Reports Table         (Gold)
    RPTGETSPEC()         Retrieve report spec from Reports Table            (Gold)
    RPTSETTINGS()        Report Settings dialog box                         (Gold)
    RPTSTRUCT()          Return structure of Reports Table                  (Gold)
    RPT_CALL()           Execute R&R report (Artful Two only)               (Two)
    RPT_COPIES()         Set number of copies for a printed report          (Two)
    RPT_DEST()           Select destination for report from Reports Table   (Two)
    RPT_EXEC()           Execute report in Reports Table (Artful Two)       (Two)
    RPT_MENU()           Select report from Reports Table                   (Both)
    RPT_OPTS()           Options for report from Reports Table              (Two)
    RPT_QUERY()          Query control for report in Reports Table          (Two)
    RPT_RESET()          Reset Report record to default settings            (Two)
    RPT_RRUN()           Run R&R report using RRUN.EXE                      (Two)
    RPT_SCOPE()          Set scope for report from Reports Table            (Two)
    RPT_STD()            Execute .FRM or .LBL report from Reports Table     (Both)
    RR4CALL()            Execute R&R report                                 (Gold)
    RRGETPRINTERS()      Return printer name array                          (Gold)
    SETJOBFILE()         Set the name of the current reports job file       (Gold)
    SETSWAPPATH()        Set swap path for execution of R&R report          (Gold)
    Back to Top

    Runtime Management, Evaluation and Error Control

    AABLOCKEXEC()        Eval code block under local error control          (Two)
    AABREAK()            Break handler for Local Error Handler              (Gold)
    AADIRDLG()           Directory spec/view dialog                         (Gold)
    AADIRS()             Return list of directories                         (Gold)
    AAERRBLOCK()         Set/Get error block for a DPD-generated menu       (Gold)
    AAERRMESSAGE()       Pop message describing an error event              (Gold)
    AAERRORLOG()         Write string or array of them to app's error log   (Gold)
    AAEXECUTE()          Evaluate a code block or macro a string            (Both)
    AAFERROR()           Low-level-file error messenger                     (Both)
    AASETTIMEOUT()       Set no-input time limit to breakout                (Both)
    AAUSERLOG()          Write Sys->UserName, date to <appName>.log         (Gold)
    AAVERSION()          Return current Artful Two/Gold version             (Both)
    ARG*()               Retrieve command-line arguments                    (Both)
    COMPILEVAL()         Compile/evaluate code block under error control    (Two)
    DO_SWAP()            Call memory swapper and run another program        (Two)
    EXEC()               Execute a DOS program or drop into DOS             (Both)
    FILES()              Return system FILES setting                        (Two)
    GET_KEYS()           Return array of the current SET KEYs               (Two)
    HANDLCOUNT()         Return the number of free or used file handles     (Two)
    HANDLES()            Install a specified number of file Handles         (Two)
    INFODIALOG()         Popup window showing runtime conditions            (Gold)
    ISARRAYSTR()         Determine if string represents an array            (Gold)
    ISBLOCKSTR()         Determine if string represents a code block        (Gold)
    ISFUNCSTR()          Determine if string represents a function call     (Gold)
    IS_*()               Determine if variable is of a specified type       (Both)
    IS_DEF()             Determine if a variable is defined                 (Both)
    IS_LINKED()          Determine if a function has been linked in         (Both)
    ISSYMBOL()           Determine if a name is in the symbol table         (Gold)
    KEYDEFAULTS()        Set key defaults for Set_Keys()                    (Two)
    LOGIN()              Generalised logIn procedure with password          (Two)
    MACRO()              Macro-expand a string, return the result           (Both)
    MACROBLOCK()         Convert a macro-string into a code block           (Both)
    MACROCOMPILE()       Compile string under local error control           (Gold)
    PASSWORD()           Get and validate a user password                   (Two)
    PROGNAME()           Return the complete pathname of the program        (Two)
    PUSH()/POP()         LIFO stack                                         (Both)
    QUITPROG()           Close up and exit a program                        (Both)
    RUN_WP()             Edit a memo field with a word processor            (Two)
    SCRAPFILES()         Manage temporary files                             (Two)
    SETUP()              Set up program environment including F setting     (Two)
    SET_KEYS()           Set or release hot-key definitions                 (Two)
    STACK*()             LIFO stack                                         (Both)
    SWAPDATAOPEN()       Set/Get file close/reopen toggle for swap          (Gold)
    SWAPPER()            Swap out program, execute another program          (Gold)
    SWAPPOSTBLOCK()      Set/Get block to execute after swap                (Gold)
    SWAPPREBLOCK()       Set/Get block to execute before swap               (Gold)
    Back to Top

    Screen and Color Methods

    AASCREEN...()        Push/pop/restore screen state                      (Both)
    BGHIDE()/FGHIDE()    Set foreground = background                        (Both)
    BIT*()               Bit manipulation                                   (Both)
    BLINK/BRIGHTFLIP()   Flip bright or blink attributes                    (Both)
    BOXER()              Draw box on screen                                 (Two)
    CENTRE()             Determine column at which to display string        (Two)
    CFADE()              Fade the screen attributes in rectangle            (Two)
    COLOR MANIPULATION   Color Manipulation functions                       (Both)
    COLORADD/MASK/SET()  Add/Mask/Set color in screen area                  (Both)
    COLORINIT()          Initialise screen attribute arrays                 (Two)
    DESKTOP()            Create a pleasant backdrop on the screen           (Both)
    DOSCOLOR()           Determine the DOS number of a Clipper colour       (Two)
    FONTINSTALL()        Install font chars for radio boxes                 (Two)
    GETCOLOR()           Return indexed colour string                       (Two)
    IS_COLOR()           Determine whether to use color or mono settings    (Both)
    MIDCOORDS()          Obtain coordinates to centre a box                 (Two)
    PARTCOLOR()          Return a portion of a colour string                (Two)
    PUSH/POP_SCR()       Save/restore a screen                              (Both)
    SCRAT()              Set screen attribute for a specified area          (Two)
    SHADOW()             Place a non-destructive Shadow on screen           (Two)
    SHADOWBOX() **       Draw a box with a Shadow behind it                 (Two)
    SYSCOLOR()           Set colour for screen output                       (Two)
    TUBE()               Show-biz box-drawing routine                       (Two)
    ZOOM_BOX()           Draw exploding box                                 (Two)
    Back to Top

    String Methods

    AABANNER()           Format a banner with left/middle/right strings     (Gold)
    AANAME()             Formatted personal name                            (Gold)
    AAPHONESTR()         Formatted phone no                                 (Gold)
    AASETQUOTES()        Set quote character for a string                   (Gold)
    AATEXTWINDOW()       View text file or array, or delimited string       (Gold)
    ABREAK()             Turn delimited string into array                   (Both)
    AFLENGTH()           Return total string length of field values         (Two)
    ALENGTH()            Find total length of strings in array              (Two)
    AMAXSTRLEN()         Find longest string in 1-dim array                 (Two)
    APAD()               Pad elements of array to specified length          (Two)
    ARRAYTOFILE()        Write array of strings to file                     (Gold)
    ATOS()               Construct string from array of strings             (Two)
    ATRANSFORM()         Fill array with transformed values                 (Two)
    ATRIM()              Trim all strings in array                          (Gold)
    CHARNEXT()           Return next non-space character in string.         (Gold)
    CHINS()              Search a string for any character in string        (Both)
    CRLF()               Add carriage return/line feed to string            (Both)
    DOLLARSTR()          Return dollars & cents amount as words             (Gold)
    ENCRYPT_IT()         Encrypt or decrypt a string                        (Two)
    EXPAND()             Double-space a string                              (Two)
    FILEWRITE()          Write a string to a DOS file                       (Two)
    FLDINKEY()           Find a field name in a string                      (Two)
    ISARRAYSTR()         Determine if string represents an array            (Gold)
    ISBLOCKSTR()         Determine if string represents a code block        (Gold)
    IS_FIELD()           Determine if a string is a fieldname               (Both)
    IS_IN()              Determine if a string is in a string or array      (Two)
    IS_KEY()             Determine if an expression is a key expression     (Two)
    IS_PHONE()           Determine if a string is a valid phone number      (Two)
    IS_PROPER()          Validation routine to force proper case            (Two)
    LONGEST()            Determine the longest in an array of strings       (Two)
    MACRO()              Macro-expand a string, return the result           (Both)
    MACROBLOCK()         Convert a macro-string into a code block           (Both)
    MACROCOMPILE()       Compile string under local error control           (Gold)
    MAKE_STR()           Turn any value into a string                       (Two)
    MIDDLE()             Center a string by padding both ends               (Two)
    MULTIPIC()           Return string of pictures for multi-field key      (Both)
    NSUBSTR()            Retrieve the nth portion of a delimited string     (Two)
    PADSYMM()            Pad a string symmetrically                         (Two)
    PROPER()             Return proper-cased string                         (Two)
    SSN()/SSNC()         Social Security Number, American/Canadian          (Both)
    STOA()               Return delimited portions of string in an array    (Two)
    STOT()               Convert seconds to a time string                   (Both)
    STRCOUNT()           Count instances of one string in another           (Gold)
    STRINGIFY()          Return character representation of data item       (Gold)
    STRINT()             Convert a number to a string                       (Both)
    STRZERO()            Turn a number into a string with leading zeroes    (Two)
    UNSTRINGIFY()        Convert string to another data type                (Gold)
    Back to Top

    Text File Methods

    AAFILEVIEW()         View text file in moused window                    (Gold)
    ARRAYTOFILE()        Write array of strings to file                     (Gold)
    FILEEDIT()           View or edit text file in memo window              (Two)
    FILETOARRAY()        Read text file into array                          (Gold)
    FILEWRITE()          Write a string to a DOS file                       (Two)
    FPOSAPPEND()         Position Ascii file pointer to append a line       (Two)
    READER()             Read a text file into a memo field                 (Both)
    READLINE()           Read a line from a text file                       (Two)
    READNEXT()           Read the next n lines of a text file               (Two)
    READPREV()           Read the previous n lines of a text file           (Two)
    READ_ARRAY()         Read the lines from a text file into an array      (Two)
    SCROLLFILE()         Scroll/pan a text file in a window                 (Two)
    UNIQUELIST()         Return array of unique text file lines             (Two)
    VIEWFILE()           Scroll/pan/print a file of any size                (Both)
    WRITELINE()          Write one line of text to an Ascii file            (Both)
    Back to Top

    Text Output Methods

    AATEXTOUT()          Send text array to printer                         (Gold)
    ADDRESS()            Compose formatted address                          (Two)
    GET_DEVICE()         Create a menu which sets device to                 (Two)
    LINEOUT()            Write line or array of lines in a report           (Both)
    OUT_OK()             Check if ESC was pressed during a report           (Two)
    PRT_LETTER()         Print a form letter                                (Two)
    SET_TARGET()         Select output destination for LIST_EM() report     (Both)
    WRITER()             Write a memo field out to an ASCII file            (Two)
    Back to Top

    The_Usual()

    AUTO_INIT()          Auto Udf_Init function for The_Usual()             (Both)
    AUTOCHILD()          Auto Udf_Init function for scoping The_Usual()     (Both)
    CHECK_REL()          Look for related tables at EoF                     (Both)
    CHILDINIT/ZOOM()     Scoped invocations of The_Usual()                  (Both)
    GO_*()               Record movement under The_Usual()                  (Both)
    INTHEUSUAL()         Determine if The_Usual() is in control.            (Two)
    KEYDEFAULTS()        Set key defaults for Set_Keys()                    (Two)
    MAKE_MENU()          Default menu builder for The_Usual()               (Both)
    PAGE()               Change screen number in multi-screen USUAL()       (Both)
    REPO_MAN()           Reports Table manager                              (Both)
    SET_BROWSE()         Fill browse arrays for The_Usual()                 (Two)
    SET_PAGE()           Activate next-page/previous-page commands          (Both)
    SET_RELAT()          Set all relations specified in a DICT record       (Both)
    SET_TABLE()          Default menu interface for THE_USUAL()             (Both)
    THE_USUAL()          File maintenance meta-function                     (Two)
    UAUTOFORCE()         Use Auto screens if custom screens not linked      (Gold)
    USETBROWSE()         Set Browse window for The_Usual()                  (Gold)
    USETCHOICES()        Set menu prompts for The_Usual()                   (Gold)
    USETMESGS()          Set menu messages for The_Usual()                  (Gold)
    USETPDFLAGS()        Set pulldown flags for The_Usual()'s menu          (Gold)
    USETRELCHECK()       Set/Get relational check block for The_Usual()     (Both)
    USETUDFS()           Set Udfs for The_Usual()'s menu                    (Gold)
    USTATS()             Administer the descriptive stats file              (Two)
    UZOOMTABLE()         Direct zoom to another table from The_Usual()      (Both)
    U_ACCESS()           Access to The_Usual()'s control info               (Two)
    U_BROWSE() **        Caller for Browser() from The_Usual()              (Both)
    U_CALC()             The_Usual()'s default Calc udf. Sum/count          (Both)
    U_EDIT()             Record edit under The_Usual() witg Get_Std2()      (Both)
    U_LIST()             The_Usual()'s interface with the Reports Table     (Both)
    U_MEMO()             The_Usual()'s interface with Read_Memo()           (Both)
    U_OUT()              Quick exit from The_Usual()                        (Both)
    U_PAGE()             The_Usual()'s multi-page screen routine            (Two)
    U_PUSH()/POP()       Push/Pop instance of The_Usual()                   (Both)
    U_QUERY()            The_Usual()'s interface with Query()               (Both)
    U_RECEDIT()          UGet() edit caller for The_Usual()                 (Both)
    U_SEARCH()           The_Usual()'s Relational find mechanism            (Both)
    U_TBROWSE()          The_Usual()'s call to TBrowser()                   (Both)
    U_ZOOM()             Default Zoom udf invoked by The_Usual()            (Both)
    Back to Top

    User Interface

    AACLRSEL()           Popup color selector                               (Gold)
    AADIALOG()           Dialog box                                         (Both)
    AAERRMESSAGE()       Pop error message based on error object            (Gold)
    AAMETER*()           Progress meter                                     (Gold)
    AASETBOX()           Set default border for Boxer()                     (Two)
    AASTLINFLASH()       Flash status line message                          (Gold)
    AASTLINON/OFF()      Push/Pop status line message                       (Both)
    AC_MENU()            Pop-up menu                                        (Two)
    ADISPLAY()           Display elements of array in window                (Both)
    AHEADS()             Create array of column headers                     (Both)
    ARRAY_FILL()         Array-based scrolling lookup table                 (Two)
    ASK_FOR()            Pop-up Get                                         (Two)
    AUTOMAINT()          Vanilla file maintenance window                    (Gold)
    BELL()               Ring Bell a number of times                        (Two)
    BLINK()              Display blinking message                           (Two)
    CALENDAR()           Pop-up calendar                                    (Two)
    COUNT_EM()           Count records matching condition, pop up result    (Both)
    DATEBOOK()           Scrolling datebook with popup calendar             (Two)
    DESKTOP()            Create a pleasant backdrop on the screen           (Both)
    ERRORMESSAGE()       Return array of strings describing error           (Both)
    FILEEDIT()           View or edit text file in memo window              (Two)
    FILEFOUND()          Determine if a file exists on the path             (Two)
    FILEOPEN()           Try to open a DOS file using FOPEN()               (Two)
    GETFILE()            Popup file selector                                (Both)
    GETFILES()           Multi-file selection dialog                        (Gold)
    GET_ALIAS()          Select a table from a dynamic menu of aliases      (Both)
    GET_DEVICE()         Create a menu which sets device to                 (Two)
    HEADER()             Create a cosmetic rendition of a field name        (Two)
    HEADLINE()           Display routine to create a screen header          (Two)
    IS_BTW()             Determine if a target lies within a range          (Both)
    LOGIN()              Generalised logIn procedure with password          (Two)
    LTOC()               Turn a logical into a character expression         (Two)
    MASK_FOR()           Popup search-target requestor with formatting      (Two)
    MSG()                A generalized message function for MaxRow()        (Two)
    NOFINDMESG()         General pop-up message for failed seeks            (Two)
    PBMENUACTIVATE()     Activate a pushbutton menu                         (Two)
    PBMENUDEACTIVATE()   Deactivate a pushbutton menu                       (Two)
    PBMENUNEW()          Create a pushbutton menu.                          (Two)
    PBMENUSHOW()         Display a pushbutton menu                          (Two)
    PBUTTONADD()         Add button to a pushbutton menu.                   (Two)
    PBUTTONNEW()         Create a pushbutton.                               (Two)
    PDACTIVATE()         Activate a pulldown menu system                    (Two)
    PD_ADDMENU()         Add a child pulldown to a parent pulldown.         (Two)
    PD_BECOME()          Assemble array of menus for PD_MENU()              (Two)
    PD_CREATE()          Create menu for use by PD_MENU()                   (Two)
    PD_MENU()            Pulldown menu system using OMenu.Prg               (Two)
    POP_MSG()            Pop up a message, wait for a keystroke             (Two)
    SCR_LINE()           Draw a line across the screen                      (Two)
    SEX()                Translate "M" or "F" into "Male" or "Female"       (Two)
    SIGN_BOX()           Draw box used by SIGN_ON() and SIGN_OFF()          (Two)
    SIGN_ON/OFF()        Opening and closing screens                        (Both)
    SNAKE()              Output a snaking list of character strings         (Two)
    SNAKENEW()           Initalize a new snake.                             (Two)
    STATUSLINE()         Display table/memory/query status on MaxRow()      (Both)
    STATUSMESG()         Set message for next invocation of StatsuLine()    (Both)
    USERBROWSE()         Select/open/browse non-application Dbfs            (Gold)
    Back to Top