| **Navigation:**  [[introduction.htm|Language Reference]] > 13 - Built-in Functions >====== Functions by Type of Usage ====== | [[built in procedures.htm|{{btn_prev_n.gif|Previous page}}]][[introduction.htm|{{btn_home_n.gif|Return to chapter overview}}]][[abs  return absolute value .htm|{{btn_next_n.gif|Next page}}]] |
|  ||

[[procedures listed by function.htm#gmctyx|Logic Control]]

[[procedures listed by function.htm#ag7j5 3|Event Processing]]

[[procedures listed by function.htm#b528lk|Multi-Threading]]

[[procedures listed by function.htm#gg9fe8|Window Processing]]

[[procedures listed by function.htm#dtvwqq|Keyboard Processing]]

[[procedures listed by function.htm#b doz8y|Windows Standard Dialogs]]

[[procedures listed by function.htm#a xv1l3|Drag and Drop Processing]]

[[procedures listed by function.htm#c19tuuy|Non-Volatile Storage Commands]]

[[procedures listed by function.htm#r5ylvt|Report Processing]]

[[procedures listed by function.htm#ai3am6h|Graphics Processing]]

[[procedures listed by function.htm#lha5nr|File Processing]]

[[procedures listed by function.htm#faq8 2n|Record Processing]]

[[procedures listed by function.htm#hrctyt|Transaction Processing]]

[[procedures listed by function.htm#dk0gxd5|Null Data Processing]]

[[procedures listed by function.htm#wb5wh3|Internationalization Support]]

[[procedures listed by function.htm#a1lsh g|View Processing]]

[[procedures listed by function.htm#btmw5sa|Queue Processing]]

[[procedures listed by function.htm#qomk85|Mathematical Procedures]]

[[procedures listed by function.htm#aytzqfl|Trigonometric Procedures]]

[[procedures listed by function.htm#wi rb6|String Processing]]

[[procedures listed by function.htm#e9t10zf|Bit Manipulation]]

[[procedures listed by function.htm#b44i qg|Date / Time Processing]]

[[procedures listed by function.htm#ag87ft|Field Access]]

[[procedures listed by function.htm#d 6mzvr|Operating System Procedures]]

[[procedures listed by function.htm#cufa9u|Error Reporting]]

[[procedures listed by function.htm#b2nepxu|Miscellaneous]]

**Logic Control**

[[chain  execute another program .htm|CHAIN (execute another program)]]

[[halt  exit program .htm|HALT (exit program)]]

[[idle  arm periodic procedure .htm|IDLE (arm periodic procedure)]]

[[run  execute command .htm|RUN (execute command)]]

[[shutdown  arm termination procedure .htm|SHUTDOWN (arm termination procedure)]]

[[stop  suspend program execution .htm|STOP (suspend program execution)]]

**Event Processing**

[[accept  the event processor .htm|ACCEPT (the event processor)]]

[[alert  set event generation key .htm|ALERT (set event generation key)]]

[[event  return event number .htm|EVENT (return event number)]]

[[post  post user defined event .htm|POST (post user-defined event)]]

[[register  register event handler .htm|REGISTER (register event handler)]]

[[unregister  unregister event handler .htm|UNREGISTER (unregister event handler)]]

[[yield  allow event processing .htm|YIELD (allow event processing)]]

**Multi-Threading**

[[start  return new execution thread .htm|START (return new execution thread)]]

[[thread  return current execution thread .htm|THREAD (return current execution thread)]]

[[unlockthread  unlock the current execution thread .htm|UNLOCKTHREAD (unlock the current execution thread)]]

[[lockthread  re lock the current execution thread .htm|LOCKTHREAD (re-lock the current execution thread)]]

[[threadlocked  returns current execution thread locked state .htm|THREADLOCKED (returns current execution thread locked state)]]

[[suspend suspend thread execution.htm|SUSPEND (suspend thread execution)]]

[[resume resume thread execution .htm|RESUME (resume thread execution)]]

**Window Processing**

[[accepted  return control just completed .htm|ACCEPTED (return control just completed)]]

[[change  change control field value .htm|CHANGE (change control field value)]]

[[choice  return relative item position .htm|CHOICE (return relative item position)]]

[[clone duplicate existing control .htm|CLONE (duplicate existing control)]]

[[close  close a data structure .htm|CLOSE (close window)]]

[[contents  return contents of use variable .htm|CONTENTS (return contents of USE variable)]]

[[create  return new control created .htm|CREATE (create new control)]]

[[destroy  remove a control .htm|DESTROY (remove a control)]]

[[disable  dim a control .htm|DISABLE (dim a control)]]

[[display  write use variables to screen .htm|DISPLAY (write USE variables to screen)]]

[[enable  re activate dimmed control .htm|ENABLE (re-activate dimmed control)]]

[[erase  clear screen control and use variables .htm|ERASE (clear screen control and USE variables)]]

[[field  return control with focus .htm|FIELD (return control with focus)]]

[[firstfield  return first window control .htm|FIRSTFIELD (return first window control)]]

[[focus  return control with focus .htm|FOCUS (return control with focus)]]

[[getfont  get font information .htm|GETFONT (get font information)]]

[[getposition  get control position .htm|GETPOSITION (get control position)]]

[[help  help window access .htm|HELP (help window access)]]

[[hide  blank a control .htm|HIDE (blank a control)]]

[[incomplete  return empty req control .htm|INCOMPLETE (return empty REQ control)]]

[[lastfield  return last window control .htm|LASTFIELD (return last window control)]]

[[message  return message box response .htm|MESSAGE (return message box response)]]

[[mousex  return mouse horizontal position .htm|MOUSEX (return mouse horizontal position)]]

[[mousey  return mouse vertical position .htm|MOUSEY (return mouse vertical position)]]

[[open  open a data structure .htm|OPEN (open window for processing)]]

[[popup  return popup menu selection .htm|POPUP (return popup menu selection)]]

[[select  select next control to process .htm|SELECT (select next control to process)]]

[[selected  return control that has received focus .htm|SELECTED (return control that has received focus)]]

[[set3dlook  set 3d window look .htm|SET3DLOOK (set 3D window look)]]

[[setcursor  set temporary mouse cursor .htm|SETCURSOR (set temporary mouse cursor)]]

[[setfont  specify font .htm|SETFONT (specify font)]]

[[setposition  specify new control position .htm|SETPOSITION (specify new control position)]]

[[settarget  set current window or report .htm|SETTARGET (set current window or report)]]

[[unhide  show hidden control .htm|UNHIDE (show hidden control)]]

[[update  write from screen to use variables .htm|UPDATE (write from screen to USE variables)]]

**Keyboard Processing**

[[alias  set alternate keycode .htm|ALIAS (set alternate keycode)]]

[[ask  get one keystroke .htm|ASK (get one keystroke)]]

[[forwardkey  pass keystrokes to control.htm|FORWARDKEY (pass keystrokes to control)]]

[[keyboard  return keystroke waiting .htm|KEYBOARD (return keystroke waiting)]]

[[keychar  return ascii code .htm|KEYCHAR (return ASCII code)]]

[[keycode  return last keycode .htm|KEYCODE (return last keycode)]]

[[keystate  return keyboard status .htm|KEYSTATE (return keyboard status)]]

[[press  put characters in the buffer .htm|PRESS (put characters in the buffer)]]

[[presskey  put a keystroke in the buffer .htm|PRESSKEY (put a keystroke in the buffer)]]

[[setkeychar  specify ascii code .htm|SETKEYCHAR (specify ASCII code)]]

[[setkeycode  specify keycode .htm|SETKEYCODE (specify keycode)]]

**Windows Standard Dialogs**

[[colordialog  return chosen color .htm|COLORDIALOG (return chosen color)]]

[[filedialog  return chosen file .htm|FILEDIALOG (return chosen file)]]

[[fontdialog  return chosen font .htm|FONTDIALOG (return chosen font)]]

[[fontdialoga  return chosen font and character set .htm|FONTDIALOGA (return chosen font and character set)]]

[[printerdialog  return chosen printer .htm|PRINTERDIALOG (return chosen printer)]]

**Drag and Drop Processing**

[[clipboard  return windows clipboard contents .htm|CLIPBOARD (return windows clipboard contents)]]

[[dragid  return matching drag and drop signature .htm|DRAGID (return matching drag-and-drop signature)]]

[[dropid  return drag and drop string .htm|DROPID (return drag-and-drop string)]]

[[setclipboard  set windows clipboard contents .htm|SETCLIPBOARD (set windows clipboard contents)]]

[[setdropid  set dropid return string .htm|SETDROPID (set DROPID return string)]]

**Non-Volatile Storage**

[[getini  return ini file entry .htm|GETINI (return INI file entry)]]

[[putini  set ini file entry .htm|PUTINI (set INI file entry)]]

[[getreg get windows registry entry .htm|GETREG (get Windows registry entry)]]

[[putreg write value to windows registry .htm|PUTREG (write value to Windows registry)]]

[[deletereg remove a value or key from windows registry .htm|DELETEREG(remove a value or key from Windows registry)]]

**Report Processing**

[[close  close a data structure .htm|CLOSE (close an active report structure)]]

[[endpage  force page overflow .htm|ENDPAGE (force page overflow)]]

[[open  open a data structure .htm|OPEN (open a report structure for processing)]]

[[print  print a report structure .htm|PRINT (print a report structure)]]

**Graphics Processing**

[[arc  draw an arc of an ellipse .htm|ARC (draw an arc of an ellipse)]]

[[blank  erase graphics .htm|BLANK (erase graphics)]]

[[box  draw a rectangle .htm|BOX (draw a rectangle)]]

[[chord  draw a section of an ellipse .htm|CHORD (draw a section of an ellipse)]]

[[ellipse  draw an ellipse .htm|ELLIPSE (draw an ellipse)]]

[[image  draw a graphic image .htm|IMAGE (draw a graphic image)]]

[[line  draw a straight line .htm|LINE (draw a straight line)]]

[[pencolor  return line draw color .htm|PENCOLOR (return line draw color)]]

[[penstyle  return line draw style .htm|PENSTYLE (return line draw style)]]

[[penwidth  return line draw thickness .htm|PENWIDTH (return line draw thickness)]]

[[pie  draw a pie chart .htm|PIE (draw a pie chart)]]

[[polygon  draw a multi sided figure .htm|POLYGON (draw a multi-sided figure)]]

[[roundbox  draw a box with round corners .htm|ROUNDBOX (draw a box with round corners)]]

[[setpencolor  set line draw color .htm|SETPENCOLOR (set line draw color)]]

[[setpenstyle  set line draw style .htm|SETPENSTYLE (set line draw style)]]

[[setpenwidth  set line draw thickness .htm|SETPENWIDTH (set line draw thickness)]]

[[show  write to screen .htm|SHOW (write to screen)]]

[[type  write string to screen .htm|TYPE (write string to screen)]]

**File Processing**

[[buffer  set record paging .htm|BUFFER (set FILE record paging)]]

[[build  build keys and indexes .htm|BUILD (build keys and indexes)]]

[[callback  register or unregister a filecallbackinterface.htm|CALLBACK (register or unregister a FileCallBackInterface)]]

[[close  close a data structure .htm|CLOSE (close a data file)]]

[[copy  copy a file .htm|COPY (copy a file)]]

[[create  create an empty data file .htm|CREATE (create an empty data file)]]

[[empty  empty a data file .htm|EMPTY (empty a data file)]]

[[flush  flush buffers .htm|FLUSH (flush buffers)]]

[[freestate  free resources .htm|FREESTATE (free resources)]]

[[getstate  return current state of data file .htm|GETSTATE (return current state of data file)]]

[[lock  exclusive file access .htm|LOCK (exclusive file access)]]

[[name  return file name .htm|NAME (return file name)]]

[[open  open a data structure .htm|OPEN (open a data file)]]

[[pack  remove deleted records .htm|PACK (remove deleted records)]]

[[records  return number of rows in data set .htm|RECORDS (return number of file or key records)]]

[[remove  erase a file .htm|REMOVE (erase a file)]]

[[rename  change file directory name .htm|RENAME (change file directory name)]]

[[restorestate  restore state of data file .htm|RESTORESTATE (restore state of data file)]]

[[send  send message to file driver .htm|SEND (send message to file driver)]]

[[sqlcallback  register or unregister a sqlcallbackinterface.htm|SQLCALLBACK (register or unregister a SQLCallBackInterface)]]

[[status  return file status .htm|STATUS (return file status)]]

[[stream  enable operating system buffering .htm|STREAM (enable operating system buffering)]]

[[unlock  unlock a locked data file .htm|UNLOCK (unlock a locked data file)]]

**Record Processing**

[[add  add an entry .htm|ADD (add a new file record)]]

[[append  add a new file record .htm|APPEND (add a new file record)]]

[[bytes  return size in bytes .htm|BYTES (return size in bytes)]]

[[delete  delete a record .htm|DELETE (delete a file record)]]

[[duplicate  check for duplicate key entries .htm|DUPLICATE (check for duplicate key entries)]]

[[get  read a record or entry .htm|GET (read a file record by direct access)]]

[[hold  exclusive record access .htm|HOLD (exclusive file record access)]]

[[next  read next record in sequence .htm|NEXT (read next file record in sequence)]]

[[nomemo  read file record without reading memo .htm|NOMEMO (read file record without reading memo)]]

[[position  return record sequence position .htm|POSITION (return file record sequence position)]]

[[previous  read previous view record in sequence .htm|PREVIOUS (read previous file record in sequence)]]

[[put  re write record .htm|PUT (write record back to file)]]

[[release  release a held record .htm|RELEASE (release a held file record)]]

[[reget  re get record .htm|REGET (reget file record)]]

[[reset  reset record sequence position .htm|RESET (reset file record sequence position)]]

[[set  initiate sequential file processing .htm|SET (initiate sequential file processing)]]

[[skip  bypass records in sequence .htm|SKIP (bypass file records in sequence)]]

[[watch  automatic concurrency check .htm|WATCH (automatic file concurrency check)]]

**Transaction Processing**

[[commit  terminate successful transaction .htm|COMMIT (terminate successful transaction)]]

[[logout  begin transaction .htm|LOGOUT (begin transaction)]]

[[rollback  terminate unsuccessful transaction .htm|ROLLBACK (terminate unsuccessful transaction)]]

**Null Data Processing**

[[getnulls get the null state of a table .htm|GETNULLS (get the NULL state of a table)]]

[[null  return null file field .htm|NULL (return null file field)]]

[[setnull  set file field null .htm|SETNULL (set file field null)]]

[[setnulls set the null state of columns .htm|SETNULLS (set the null state of columns)]]

[[setnonull  set file field non null .htm|SETNONNULL (set file field non-null)]]

**Internationalization Support**

[[convertansitooem  convert ansi strings to ascii .htm|CONVERTANSITOOEM (convert ANSI strings to ASCII)]]

[[convertoemtoansi  convert ascii strings to ansi .htm|CONVERTOEMTOANSI (convert ASCII strings to ANSI)]]

[[isalpha  return alphabetic character .htm|ISALPHA (return alphabetic character)]]

[[islower  return lower case character .htm|ISLOWER (return lower case character)]]

[[isupper  return upper case character .htm|ISUPPER (return upper case character)]]

[[locale  load environment file .htm|LOCALE (load environment file)]]

**View Processing**

[[buffer  set record paging .htm|BUFFER (set VIEW record paging)]]

[[callback  register or unregister a filecallbackinterface.htm|CALLBACK (register or unregister a FileCallBackInterface)]]

[[close  close a data structure .htm|CLOSE (close a VIEW)]]

[[open  open a data structure .htm|OPEN (open a VIEW)]]

[[delete  delete a record .htm|DELETE (delete a view primary file record)]]

[[flush  flush buffers .htm|FLUSH (flush buffers)]]

[[hold  exclusive record access .htm|HOLD (exclusive view record access)]]

[[next  read next record in sequence .htm|NEXT (read next view record in sequence)]]

[[position  return record sequence position .htm|POSITION (return view record sequence position)]]

[[previous  read previous view record in sequence .htm|PREVIOUS (read previous view record in sequence)]]

[[put  re write record .htm|PUT (write VIEW primary file record back)]]

[[records  return number of rows in data set .htm|RECORDS (return number of rows in data set)]]

[[reget  re get record .htm|REGET (reget view record)]]

[[release  release a held record .htm|RELEASE (release a held view record)]]

[[reset  reset record sequence position .htm|RESET (reset view record sequence position)]]

[[set  initiate sequential file processing .htm|SET (set view record sequence position)]]

[[skip  bypass records in sequence .htm|SKIP (bypass view records in sequence)]]

[[sql  use sql code .htm|SQL (use SQL code)]]

[[sqlcallback  register or unregister a sqlcallbackinterface.htm|SQLCALLBACK (register or unregister an SQLCallBackInterface)]]

[[watch  automatic concurrency check .htm|WATCH (automatic view concurrency check)]]

**Queue Processing**

[[add  add an entry .htm|ADD (add an entry)]]

[[changes  return changed queue .htm|CHANGES (return changed queue)]]

[[delete  delete a record .htm|DELETE (delete an entry)]]

[[free  delete all entries .htm|FREE (delete all entries)]]

[[get  read a record or entry .htm|GET (read an entry)]]

[[pointer  return last queue entry position .htm|POINTER (return last entry position)]]

[[position  return record sequence position .htm|POSITION (return record sequence position)]]

[[put  re write record .htm|PUT (write an entry)]]

[[records  return number of rows in data set .htm|RECORDS (return number of entries)]]

[[sort  sort queue entries .htm|SORT (sort entries)]]

**Mathematical Procedures**

[[abs  return absolute value .htm|ABS (return absolute value)]]

[[inrange  check number within range .htm|INRANGE (check number within range)]]

[[int  truncate fraction .htm|INT (truncate fraction)]]

[[loge  return natural logarithm .htm|LOGE (return natural logarithm)]]

[[log10  return base 10 logarithm .htm|LOG10 (return base 10 logarithm)]]

[[random  return random number .htm|RANDOM (return random number)]]

[[round  return rounded number .htm|ROUND (return rounded number)]]

[[sqrt  return square root .htm|SQRT (return square root)]]

**Trigonometric Procedures**

[[sin  return sine .htm|SIN (return sine)]]

[[cos  return cosine .htm|COS (return cosine)]]

[[tan  return tangent .htm|TAN (return tangent)]]

[[asin  return arcsine .htm|ASIN (return arcsine)]]

[[acos  return arccosine .htm|ACOS (return arccosine)]]

[[atan  return arctangent .htm|ATAN (return arctangent)]]

**String Processing**

[[all  return repeated characters .htm|ALL (return repeated characters)]]

[[center  return centered string .htm|CENTER (return centered string)]]

[[chr  return character from ascii .htm|CHR (return character from ASCII)]]

[[clip  return string without trailing spaces .htm|CLIP (return string without trailing spaces)]]

[[deformat  return unformatted numbers from string .htm|DEFORMAT (return unformatted numbers from string)]]

[[format  return formatted numbers into a picture .htm|FORMAT (return formatted numbers into a picture)]]

[[inlist  return entry in list .htm|INLIST (return entry in list)]]

[[instring  return substring position .htm|INSTRING (return substring position)]]

[[left  return left justified string .htm|LEFT (return left justified string)]]

[[len  return length of string .htm|LEN (return length of string)]]

[[lower  return lower case .htm|LOWER (return lower case)]]

[[match  return matching values .htm|MATCH (return matching strings)]]

[[numeric  return numeric string .htm|NUMERIC (return numeric string)]]

[[right  return right justified string .htm|RIGHT (return right justified string)]]

[[sub  return substring of string .htm|SUB (return substring of string)]]

[[tie associate a string value to an astring .htm|TIE (associate a string value to an ASTRING)]]

[[tied retrieves a value associated with an astring.htm|TIED (retrieves a value associated with an ASTRING)]]

[[untie disassociate a string value from an astring .htm|UNTIE (disassociate a string value from an ASTRING)]]

[[upper  return upper case .htm|UPPER (return upper case)]]

[[val  return ascii value .htm|VAL (return ASCII value)]]

**Bit Manipulation**

[[band  return bitwise and .htm|BAND (return bitwise AND)]]

[[bor  return bitwise or .htm|BOR (return bitwise OR)]]

[[bxor  return bitwise exclusive or .htm|BXOR (return bitwise exclusive OR)]]

[[bshift  return shifted bits .htm|BSHIFT (return shifted bits)]]

**Date / Time Processing**

[[today  return system date .htm|TODAY (return system date)]]

[[settoday  set system date .htm|SETTODAY (set system date)]]

[[clock  return system time .htm|CLOCK (return system time)]]

[[setclock  set system time .htm|SETCLOCK (set system time)]]

[[date  return standard date .htm|DATE (return standard date)]]

[[day  return day of month .htm|DAY (return day of month)]]

[[month  return month of date .htm|MONTH (return month of date)]]

[[year  return year of date .htm|YEAR (return year of date)]]

[[age  return age from base date .htm|AGE (return age from base date)]]

**Field Access**

[[isstring  return field string type or not .htm|ISSTRING (return field string type or not)]]

[[what  return field from group .htm|WHAT (return field from group)]]

[[where  return field position in group .htm|WHERE (return field position in group)]]

**Operating System Procedures**

[[command  return command line .htm|COMMAND (return command line)]]

[[directory  get file directory .htm|DIRECTORY (get file directory)]]

[[longpath  return long filename .htm|LONGPATH (return long filename)]]

[[path  return current directory .htm|PATH (return current directory)]]

[[runcode  return program exit code .htm|RUNCODE (return program exit code)]]

[[setcommand  set command line parameters .htm|SETCOMMAND (set command line parameters)]]

[[setpath  change current drive and directory .htm|SETPATH (change current drive and directory)]]

[[shortpath  return short filename .htm|SHORTPATH (return short filename)]]

**Error Reporting**

[[error  return error message .htm|ERROR (return error message)]]

[[errorcode  return error code number .htm|ERRORCODE (return error code number)]]

[[errorfile  return error filename .htm|ERRORFILE (return error filename)]]

[[fileerror  return file driver error message .htm|FILEERROR (return file driver error message)]]

[[fileerrorcode  return file driver error code number .htm|FILEERRORCODE (return file driver error code number)]]

[[rejectcode  return reject code number .htm|REJECTCODE (return reject code number)]]

**Miscellaneous**

[[address  return memory address .htm|ADDRESS (return memory address)]]

[[beep  sound tone on speaker .htm|BEEP (sound tone on speaker)]]

[[call  call procedure from a dll .htm|CALL (call procedure from a DLL)]]

[[choose  return chosen value .htm|CHOOSE (return chosen value)]]

[[maximum  return maximum subscript value .htm|MAXIMUM (return maximum subscript value)]]

[[omitted  return omitted parameters .htm|OMITTED (return omitted parameters)]]

[[peek  read memory address .htm|PEEK (read memory address)]]

[[poke  write to memory address .htm|POKE (write to memory address)]]

[[unload  remove a called dll from memory .htm|UNLOAD (remove a CALLed DLL from memory)]]