Clarion Community Help

Navigation: Language Reference > 13 - Built-in Functions >====== Built-in Functions ======

List by type of functionality:

Windows Standard Dialogs

Drag and Drop Processing

Maintaining INI Files

Transaction Processing

Null Data Processing

Internationalization Support

View Processing

Queue Processing

Mathematical Procedures

Trigonometric Procedures

String Processing

Bit Manipulation

Date / Time Processing

Field Access

Operating System Procedures

Error Reporting

Miscellaneous

Alphabetical list:

ABS (return absolute value)

ACCEPTED (return control just completed)

ACOS (return arccosine)

ADD (add an entry)

ADDRESS (return memory address)

AGE (return age from base date)

ALERT (set event generation key)

ALIAS (set alternate keycode)

ALL (return repeated characters)

APPEND (add a new file record)

ARC (draw an arc of an ellipse)

ASK (get one keystroke)

ASIN (return arcsine)

ATAN (return arctangent)

BAND (return bitwise AND)

BEEP (sound tone on speaker)

BLANK (erase graphics)

BOR (return bitwise OR)

BOX (draw a rectangle)

BSHIFT (return shifted bits)

BUFFER (set record paging)

BUILD (build keys and indexes)

BXOR (return bitwise exclusive OR)

BYTES (return size in bytes)

CALL (call procedure from a DLL)

CALLBACK (register or unregister a FileCallBackInterface)

CENTER (return centered string)

CHAIN (execute another program)

CHANGE (change control field value)

CHANGES (return changed queue)

CHOICE (return relative item position)

CHOOSE (return chosen value)

CHORD (draw a section of an ellipse)

CHR (return character from ASCII)

CLIP (return string without trailing spaces)

CLIPBOARD (return windows clipboard contents)

CLOCK (return system time)

CLONE (duplicate existing control)

CLOSE (close a data structure)

COLORDIALOG (return chosen color)

COMMAND (return command line)

COMMIT (terminate successful transaction)

CONTENTS (return contents of USE variable)

CONVERTANSITOOEM (convert ANSI strings to ASCII)

CONVERTOEMTOANSI (convert ASCII strings to ANSI)

COPY (copy a file)

COS (return cosine)

CREATE (create an empty data file)

CREATE (return new control created)

DATE (return standard date)

DAY (return day of month)

DEFORMAT (return unformatted numbers from string)

DELETE (delete a record)

DESTROY (remove a control)

DIRECTORY (get file directory)

DISABLE (dim a control)

DISPLAY (write USE variables to screen)

DRAGID (return matching drag-and-drop signature)

DROPID (return drag-and-drop string)

DUPLICATE (check for duplicate key entries)

ELLIPSE (draw an ellipse)

EMPTY (empty a data file)

ENABLE (re-activate dimmed control)

ENDPAGE (force page overflow)

ERASE (clear screen control and USE variables)

ERROR (return error message)

ERRORCODE (return error code number)

ERRORFILE (return error filename)

EVENT (return event number)

EXISTS (return file existence)

FIELD (return control with focus)

FILEDIALOG (return chosen file)

FILEERROR (return file driver error message)

FILEERRORCODE (return file driver error code number)

FIRSTFIELD (return first window control)

FLUSH (flush buffers)

FOCUS (return control with focus)

FONTDIALOG (return chosen font)

FONTDIALOGA (return chosen font and character set)

FORMAT (return formatted numbers into a picture)

FORWARDKEY (pass keystrokes to control)

FREE (delete all entries)

FREESTATE (free resources)

GET (read a record or entry)

GETFONT (get font information)

GETINI (return INI file entry)

GETNULLS (get the NULL state of a table)

GETPOSITION (get control position)

GETSTATE (return current state of data file)

HALT (exit program)

HELP (help window access)

HIDE (blank a control)

HOLD (exclusive record access)

IDLE (arm periodic procedure)

IMAGE (draw a graphic image)

INCOMPLETE (return empty REQ control)

INLIST (return entry in list)

INRANGE (check number within range)

INSTRING (return substring position)

INT (truncate fraction)

ISALPHA (return alphabetic character)

ISLOWER (return lower case character)

ISSTRING (return field string type or not)

ISUPPER (return upper case character)

KEYBOARD (return keystroke waiting)

KEYCHAR (return ASCII code)

KEYCODE (return last keycode)

KEYSTATE (return keyboard status)

LASTFIELD (return last window control)

LEFT (return left justified string)

LEN (return length of string)

LINE (draw a straight line)

LOCALE (load environment file)

LOCK (exclusive file access)

LOCKTHREAD (re-lock the current execution thread)

LOG10 (return base 10 logarithm)

LOGE (return natural logarithm)

LOGOUT (begin transaction)

LONGPATH (return long filename)

LOWER (return lower case)

MATCH (return matching values)

MAXIMUM (return maximum subscript value)

MESSAGE (return message box response)

MONTH (return month of date)

MOUSEX (return mouse horizontal position)

MOUSEY (return mouse vertical position)

NAME (return file name)

NEXT (read next record in sequence)

NOMEMO (read file record without reading memo)

NULL (return null file field)

NUMERIC (return numeric string)

OMITTED (return omitted parameters)

OPEN (open a data structure)

PACK (remove deleted records)

PATH (return current directory)

PEEK (read memory address)

PENCOLOR (return line draw color)

PENSTYLE (return line draw style)

PENWIDTH (return line draw thickness)

PIE (draw a pie chart)

POINTER (return last queue entry position)

POKE (write to memory address)

POLYGON (draw a multi-sided figure)

POPUP (return popup menu selection)

POSITION (return record sequence position)

POST (post user-defined event)

PRESS (put characters in the buffer)

PRESSKEY (put a keystroke in the buffer)

PREVIOUS (read previous view record in sequence)

PRINT (print a report structure)

PRINTERDIALOG (return chosen printer)

PUT (re-write record)

PUTINI (set INI file entry)

RANDOM (return random number)

RECORDS (return number of rows in data set)

REGISTER (register event handler)

REJECTCODE (return reject code number)

REGET (re-get record)

RELEASE (release a held record)

REMOVE (erase a file)

RENAME (change file directory name)

RESET (reset record sequence position)

RESTORESTATE (restore state of data file)

RIGHT (return right justified string)

ROLLBACK (terminate unsuccessful transaction)

ROUND (return rounded number)

ROUNDBOX (draw a box with round corners)

RUN (execute command)

RUNCODE (return program exit code)

SELECT (select next control to process)

SELECTED (return control that has received focus)

SEND (send message to file driver)

SET (initiate sequential file processing)

SET3DLOOK (set 3D window look)

SETCLIPBOARD (set windows clipboard contents)

SETCLOCK (set system time)

SETCOMMAND (set command line parameters)

SETCURSOR (set temporary mouse cursor)

SETDROPID (set DROPID return string)

SETFONT (specify font)

SETKEYCHAR (specify ASCII code)

SETKEYCODE (specify keycode)

SETNONULL (set file field non-null)

SETNULL (set file field null)

SETNULLS (set the null state of columns)

SETPATH (change current drive and directory)

SETPENCOLOR (set line draw color)

SETPENSTYLE (set line draw style)

SETPENWIDTH (set line draw thickness)

SETPOSITION (specify new control position)

SETTARGET (set current window or report)

SETTODAY (set system date)

SHORTPATH (return short filename)

SHOW (write to screen)

SHUTDOWN (arm termination procedure)

SIN (return sine)

SKIP (bypass records in sequence)

SORT (sort queue entries)

SQL (use SQL code)

SQLCALLBACK (register or unregister a SQLCallBackInterface)

SQRT (return square root)

START (return new execution thread)

STATUS (return file status)

STOP (suspend program execution)

STREAM (enable operating system buffering)

SUB (return substring of string)

TAN (return tangent)

THREAD (return current execution thread)

THREADLOCKED (returns current execution thread locked state)

TIE (associate a string value to an ASTRING)

TIED (retrieves a value associated with an ASTRING)

TODAY (return system date)

TYPE (write string to screen)

UNHIDE (show hidden control)

UNLOAD (remove a CALLed DLL from memory)

UNLOCK (unlock a locked data file)

UNLOCKTHREAD (unlock the current execution thread)

UNREGISTER (unregister event handler)

UNTIE (disassociate a string value from an ASTRING)

UPDATE (write from screen to USE variables)

UPPER (return upper case)

VAL (return ASCII value)

WATCH (automatic concurrency check)

WHAT (return field from group)

WHERE (return field position in group)

WHO (return field name from group)

YEAR (return year of date)

YIELD (allow event processing)