차이점

이 페이지의 선택한 이전 버전과 현재 버전 사이의 차이점을 보여줍니다.

차이 보기로 연결

clipper5.3_함수 [2012/07/30 10:37] (현재)
admin 새로 만듦
줄 1: 줄 1:
 +<code> 
 +AADD()          Add a new element to the end of an array 
 + ABS()            Return the absolute value of a numeric expression 
 + ACHOICE()        Execute a pop-up menu 
 + ACLONE()        Duplicate a nested or multidimensional array 
 + ACOPY()          Copy elements from one array to another 
 + ADEL()          Delete an array element 
 + ADIR()*        Fill a series of arrays with directory information 
 + AEVAL()          Execute a code block for each element in an array 
 + AFIELDS()*      Fill arrays with the structure of the current database file 
 + AFILL()        Fill an array with a specified value 
 + AINS()        Insert a NIL element into an array 
 + ALERT()          Display a simple modal dialog box 
 + ALIAS()          Return a specified work area alias 
 + ALLTRIM()        Remove leading and trailing spaces from a character string 
 + ALTD()          Invoke the CA-Clipper debugger 
 + ARRAY()          Create an uninitialized array of specified length 
 + ASC()          Convert a character to its ASCII value 
 + ASCAN()          Scan an array for a value or until a block returns true (.T.) 
 + ASIZE()        Grow or shrink an array 
 + ASORT()          Sort an array 
 + AT()            Return the position of a substring within a character string 
 + ATAIL()          Return the highest numbered element of an array 
 + BIN2I()        Convert a 16-bit signed integer to a numeric value 
 + BIN2L()        Convert a 32-bit signed integer to a numeric value 
 + BIN2W()          Convert a 16-bit unsigned integer to a numeric value 
 + BLOBDIRECTEXP() Export the contents of a BLOB pointer to a file 
 + BLOBDIRECTGET() Retrieve data from a BLOB file without referencing a field 
 + BLOBDIRECTIMP() Import a file into a BLOB file and return pointer to the data 
 + BLOBDIRECTPUT() Put data in a BLOB file without referencing a specific field 
 + BLOBEXPORT()    Copy the contents of a memo field number to a BLOB file 
 + BLOBGET()        Get the contents of a BLOB, identified by memo field number 
 + BLOBIMPORT()    Read the contents of a BLOB file into a memo field 
 + BLOBROOTGET()    Retrieve the data from the root area of a BLOB file 
 + BLOBROOTLOCK()  Obtain a lock on the root area of a BLOB file 
 + BLOBROOTPUT()    Store data in the root area of a BLOB file 
 + BLOBROOTUNLOC() Release the lock on a BLOB file's root area 
 + BOF()            Determine when beginning of file is encountered 
 + BREAK()          Branch out of a BEGIN SEQUENCE...END construct 
 + BROWSE()*        Browse records within a window 
 + CDOW()          Convert a date value to a character day of the week 
 + CHR()            Convert an ASCII code to a character value 
 + CMONTH()        Convert a date to a character month name 
 + COL()            Return the screen cursor column position 
 + COLORSELECT()    Activate attribute in current color settings 
 + CTOD()          Convert a date string to a date value 
 + CURDIR()        Return the current DOS directory 
 + DATE()          Return the system date as a date value 
 + DAY()            Return the day of the month as a numeric value 
 + DBAPPEND() Append a new record to the database in the current work area 
 + DBCLEARFIL()    Clear a filter condition 
 + DBCLEARIND()    Close all indexes for the current work area 
 + DBCLEARREL()    Clear active relations 
 + DBCLOSEALL()    Close all occupied work areas 
 + DBCLOSEAREA()    Close a work area 
 + DBCOMMIT()      Flush pending updates 
 + DBCOMMITALL()    Flush pending updates in all work areas 
 + DBCREATE()      Create a database file from a database structure array 
 + DBCREATEIND()    Create an index file 
 + DBDELETE()      Mark a record for deletion 
 + DBEDIT()        Browse records in a table layout 
 + DBEVAL() Evaluate code block for each record matching scope/condition 
 + DBF()*        Return current alias name 
 + DBFIELDINFO()    Return and optionally change information about a field 
 + DBFILEGET()      Insert the contents of a field into a file 
 + DBFILEPUT()      Insert the contents of a file into a field 
 + DBFILTER()      Return the current filter expression as a character string 
 + DBGOBOTTOM()    Move to the last logical record 
 + DBGOTO()        Position record pointer to a specific identity 
 + DBGOTOP()        Move to the first logical record 
 + DBINFO()        Return and optionally change database file information 
 + DBORDERINFO()    Return and optionally change order and index file information 
 + DBRECALL()      Reinstate a record marked for deletion 
 + DBRECORDINFO()  Return and optionally change information about a record 
 + DBREINDEX()      Recreate all active indexes for the current work area 
 + DBRELATION()    Return the linking expression of a specified relation 
 + DBRLOCK()        Lock the record at the current or specified identity 
 + DBRLOCKLIST()    Return an array of the current lock list 
 + DBRSELECT()      Return the target work area number of a relation 
 + DBRUNLOCK()      Release all or specified record locks 
 + DBSEEK()        Move to the record having the specified key value 
 + DBSELECTAR()    Change the current work area 
 + DBSETDRIVER()    Return the database driver and optionally set a new driver 
 + DBSETFILTER()    Set a filter condition 
 + DBSETINDEX()    Empty orders from an order bag into the order list 
 + DBSETORDER()    Set the controlling order 
 + DBSETRELAT()    Relate two work areas 
 + DBSKIP()        Move relative to the current record 
 + DBSTRUCT()      Create an array containing the structure of a database file 
 + DBUNLOCK()      Release all locks for the current work area 
 + DBUNLOCKALL()    Release all locks for all work areas 
 + DBUSEAREA()      Use a database file in a work area 
 + DELETED()        Return the deleted status of the current record 
 + DESCEND()        Create a descending index key value 
 + DEVOUT()        Write a value to the current device 
 + DEVOUTPICT()    Write a value to the current device using a picture clause 
 + DEVPOS()        Move the cursor or printhead to a new position 
 + DIRCHANGE()      Change the current DOS directory 
 + DIRECTORY()      Create an array of directory and file information 
 + DIRMAKE()        Create a directory 
 + DIRREMOVE()      Remove a directory 
 + DISKCHANGE()    Change the current DOS disk drive 
 + DISKNAME()      Return the current DOS drive 
 + DISKSPACE()      Return the space available on a specified disk 
 + DISPBEGIN()      Begin buffering screen output 
 + DISPBOX()        Display a box on the screen 
 + DISPCOUNT()      Return the number of pending DISPEND() requests 
 + DISPEND()        Display buffered screen updates 
 + DISPOUT()        Write a value to the display 
 + DOSERROR()      Return the last DOS error number 
 + DOW()            Convert a date value to a numeric day of the week 
 + DTOC()          Convert a date value to a character string 
 + DTOS()          Convert a date value to a string formatted as yyyymmdd 
 + EMPTY()          Determine if the result of an expression is empty 
 + EOF()          Determine when end of file is encountered 
 + ERRORBLOCK()    Post a code block to execute when a runtime error occurs 
 + ERRORLEVEL()    Set the CA-Clipper return code 
 + EVAL()          Evaluate a code block 
 + EXP()          Calculate e**x 
 + FCLOSE()        Close an open binary file and write DOS buffers to disk 
 + FCOUNT()        Return the number of fields in the current .dbf file 
 + FCREATE()        Create and/or truncate a binary file to zero-length 
 + FERASE()        Delete a file from disk 
 + FERROR()        Test for errors after a binary file operation 
 + FIELDBLOCK()    Return a set-get code block for a given field 
 + FIELDGET()      Retrieve the value of a field using the field position 
 + FIELDNAME()    Return a field name from the current database (.dbf) file 
 + FIELDPOS()      Return the position of a field in a work area 
 + FIELDPUT()      Set the value of a field variable using the field position 
 + FIELDWBLOCK()    Return a set-get code block for a field in a given work area 
 + FILE()          Determine if files exist in the default directory or path 
 + FKLABEL()*      Return function key name 
 + FKMAX()*        Return number of function keys as a constant 
 + FLOCK()          Lock an open and shared database file 
 + FOPEN()          Open a binary file 
 + FOUND()          Determine if the previous search operation succeeded 
 + FREAD()          Read characters from a binary file into a buffer variable 
 + FREADSTR()      Read characters from a binary file 
 + FRENAME()        Change the name of a file 
 + FSEEK()          Set a binary file pointer to a new position 
 + FWRITE()        Write to an open binary file 
 + GBMPDISP()      Display a bitmap (.BMP) file on screen 
 + GBMPLOAD()      Load a bitmap (.bmp) or icon (.ico) file into memory 
 + GELLIPSE()      Draw an ellipse or circle 
 + GETACTIVE()      Return the currently active Get object 
 + GETAPPLYKEY()    Apply a key to a Get object from within a  reader 
 + GETDOSETKEY()    Process SET KEY during GET editing 
 + GETENV()        Retrieve the contents of a DOS environment variable 
 + GETPOSTVALID()  Postvalidate the current Get object 
 + GETPREVALID()    Prevalidate a Get object 
 + GETREADER()      Execute standard READ behavior for a Get object 
 + GFNTERASE()      Erase a font from memory 
 + GFNTLOAD()      Load a font file into memory 
 + GFNTSET()        Set an already loaded font as active 
 + GFRAME()        Draw a frame with a 3-D look 
 + GGETPIXEL()      Get color information for a pixel 
 + GLINE()          Draw a line in graphic mode 
 + GMODE()          Switch video mode 
 + GPOLYGON()      Draw a polygon on screen 
 + GPUTPIXEL()      Draw a pixel on the screen 
 + GRECT()          Draw a rectangle in graphic mode 
 + GSETCLIP()      Define the allowed display area 
 + GSETEXCL()      Define a screen region to be excluded from display 
 + GSETPAL()        Change components of a color 
 + GWRITEAT()      Draw graphic text without background 
 + HARDCR()        Replace all soft carriage returns with hard carriage returns 
 + HEADER()        Return the current database file header length 
 + I2BIN()        Convert a CA-Clipper numeric to a 16-bit binary integer 
 + IF()            Return the result of an expression based on a condition 
 + IIF()            Return the result of an expression based on a condition 
 + INDEXEXT()      Return index extension defined by the current database driver 
 + INDEXKEY()      Return the key expression of a specified index 
 + INDEXORD()      Return the order position of the controlling index 
 + INKEY() Extract a character from the keyboard buffer or a mouse event 
 + INT()          Convert a numeric value to an integer 
 + ISALPHA()        Determine if the leftmost character in a string is alphabetic 
 + ISCOLOR()        Determine if the current computer has color capability 
 + ISDIGIT()      Determine if the leftmost character in a string is a digit 
 + ISLOWER()        Determine if the leftmost character is a lowercase letter 
 + ISPRINTER()      Determine whether LPT1 is ready 
 + ISUPPER()        Determine if the leftmost character in a string is uppercase 
 + L2BIN() Convert a CA-Clipper numeric value to a 32-bit binary integer 
 + LASTKEY()        Return INKEY() value of last key extracted from the keyboard 
 + LASTREC()        Determine the number of records in the current .dbf file 
 + LEFT()          Extract substring beginning with first character in a string 
 + LEN()          Return the length of a string or number of array elements 
 + LOG()          Calculate the natural logarithm of a numeric value 
 + LOWER()          Convert uppercase characters to lowercase 
 + LTRIM()          Remove leading spaces from a character string 
 + LUPDATE()        Return the last modification date of a database (.dbf) file 
 + MAX()            Return the larger of two numeric or date values 
 + MAXCOL()        Determine the maximum visible screen column 
 + MAXROW()        Determine the maximum visible screen row 
 + MCOL()          Determine the mouse cursor's screen column position 
 + MDBLCLK()        Determine the double-click speed threshold of the mouse 
 + MEMOEDIT()      Display or edit character strings and memo fields 
 + MEMOEDIT()      continued... 
 + MEMOLINE()      Extract a line of text from a character string or memo field 
 + MEMOREAD()      Return the contents of a disk file as a character string 
 + MEMORY()        Determine the amount of available free pool memory 
 + MEMOSETSUPER() Set an RDD inheritance chain for the DBFMEMO database driver 
 + MEMOTRAN()      Replace carriage return/linefeeds in character strings 
 + MEMOWRIT()      Write a character string or memo field to a disk file 
 + MEMVARBLOCK()    Return a set-get code block for a given memory variable 
 + MENUMODAL()      Activate a top bar menu 
 + MHIDE()          Hide the mouse pointer 
 + MIN()          Return the smaller of two numeric or date values 
 + MLCOUNT()        Count the number of lines in a character string or memo field 
 + MLCTOPOS()      Return position of a string based on line and column position 
 + MLEFTDOWN()      Determine the press status of the left mouse button 
 + MLPOS()          Determine the position of a line in a string or memo field 
 + MOD()*          Return the dBASE III PLUS modulus of two numbers 
 + MONTH()          Convert a date value to the number of the month 
 + MPOSTOLC()      Return line/ column position of a string based on a position 
 + MPRESENT()      Determine if a mouse is present 
 + MRESTSTATE()    Re-establish the previous state of a mouse 
 + MRIGHTDOWN()    Determine the status of the right mouse button 
 + MROW()          Determine a mouse cursor's screen row position 
 + MSAVESTATE()    Save the current state of a mouse 
 + MSETBOUNDS()    Set screen boundaries for the mouse cursor 
 + MSETCLIP()      Define an inclusion region 
 + MSETCURSOR()    Determine a mouse's visibility 
 + MSETPOS()        Set a new position for the mouse cursor 
 + MSHOW()          Display the mouse pointer 
 + MSTATE()        Return the current mouse state 
 + NETERR()        Determine if a network command has failed 
 + NETNAME()        Return the current workstation identification 
 + NEXTKEY()        Read the pending key in the keyboard buffer 
 + NOSNOW()        Toggle snow suppression 
 + ORDBAGEXT()      Return the default order bag RDD extension 
 + ORDBAGNAME()    Return the order bag name of a specific order 
 + ORDCOND()        Specify conditions for ordering 
 + ORDCONDSET()    Set the condition and scope for an order 
 + ORDCREATE()      Create an order in an order bag 
 + ORDDESCEND()    Return and optionally change the descending flag of an order 
 + ORDDESTROY()    Remove a specified order from an order bag 
 + ORDFOR()        Return the FOR expression of an order 
 + ORDISUNIQUE()    Return the status of the unique flag for a given order 
 + ORDKEY()        Return the key expression of an order 
 + ORDKEYADD()      Add a key to a custom built order 
 + ORDKEYCOUNT()    Return the number of keys in an order 
 + ORDKEYDEL()      Delete a key from a custom built order 
 + ORDKEYGOTO()    Move to a record specified by its logical record number 
 + ORDKEYNO()      Get the logical record number of the current record 
 + ORDKEYVAL()      Get key value of the current record from controlling order 
 + ORDLISTADD()    Add orders to the order list 
 + ORDLISTCLEAR()  Clear the current order list 
 + ORDLISTREBUI()  Rebuild all orders in the order list of the current work area 
 + ORDNAME()        Return the name of an order in the order list 
 + ORDNUMBER()      Return the position of an order in the current order list 
 + ORDSCOPE()      Set or clear the boundaries for scoping key values 
 + ORDSETFOCUS()    Set focus to an order in an order list 
 + ORDSETRELAT()    Relate a specified work 
 + ORDSKIPUNIQUE() Move record pointer to the next or previous unique key 
 + OS()          Return the operating system name 
 + OUTERR()        Write a list of values to the standard error device 
 + OUTSTD()        Write a list of values to the standard output device 
 + PAD()            Pad character, date, and numeric values with a fill character 
 + PCOL()          Return the current column position of the printhead 
 + PCOUNT()        Determine the position of the last actual parameter passed 
 + PROCLINE()      Return source line number of current or previous activation 
 + PROCNAME()      Return name of the current or previous procedure or function 
 + PROW()          Return the current row position of the printhead 
 + QOUT()          Display a list of expressions to the console 
 + RAT()            Return the position of the last occurrence of a substring 
 + RDDLIST()        Return an array of the RDDs 
 + RDDNAME()        Return name of RDD active in current or specified work area 
 + RDDSETDEFAULT() Set or return the default RDD for the application 
 + READEXIT()      Toggle Up arrow and Down arrow as READ exit keys 
 + READFORMAT()    Return and optionally set code block to implement format file 
 + READINSERT()    Toggle the current insert mode for READ and MEMOEDIT() 
 + READKEY()*      Determine what key terminated a READ 
 + READKILL()      Return and optionally set whether current READ can be exited 
 + READMODAL()      Activate a full-screen editing mode for a GetList 
 + READUPDATED()    Determine whether any GET variables changed during a READ 
 + READVAR()        Return the current GET/MENU variable name 
 + RECCOUNT()*      Determine the number of records in the current database file 
 + RECNO()          Return the identity at the position of the record pointer 
 + RECSIZE()        Determine the record length of a database (.dbf) file 
 + REPLICATE()      Return a string repeated a specified number of times 
 + RESTSCREEN()    Display a saved screen region to a specified location 
 + RIGHT()          Return a substring beginning with the rightmost character 
 + RLOCK()          Lock the current record in the active work area 
 + ROUND() Return a numeric value rounded to a specified number of digits 
 + ROW()            Return the screen row position of the cursor 
 + RTRIM()          Remove trailing spaces from a character string 
 + SAVESCREEN()    Save a screen region for later display 
 + SCROLL()        Scroll a screen region up or down, right or left 
 + SECONDS()        Return the number of seconds elapsed since midnight 
 + SELECT()        Determine the work area number of a specified alias 
 + SET()          Inspect or change a system setting 
 + SETBLINK()      Toggle * interpretation between blinking/background intensity 
 + SETCANCEL()      Toggle Alt+C and Ctrl+Break as program termination keys 
 + SETCOLOR()      Return the current colors and optionally set new colors 
 + SETCURSOR()      Set the cursor shape 
 + SETKEY()        Assign an action block to a key 
 + SETMODE() Change display mode to a specified number of rows and columns 
 + SETPOS()        Move the cursor to a new position 
 + SETPRC()        Set PROW() and PCOL() values 
 + SOUNDEX()        Convert a character string to "soundex" form 
 + SPACE()          Return a string of spaces 
 + SQRT()          Return the square root of a positive number 
 + STR()          Convert a numeric expression to a character string 
 + STRTRAN()        Search and replace characters within a string or memo field 
 + STUFF()          Delete and insert characters in a string 
 + SUBSTR()        Extract a substring from a character string 
 + TIME()          Return the system time 
 + TONE()          Sound a speaker tone for a specified frequency and duration 
 + TRANSFORM()      Convert any value into a formatted character string 
 + TRIM()          Remove trailing spaces from a character string 
 + TYPE()          Determine the type of an expression 
 + UPDATED()        Determine whether a GET changed during a READ 
 + UPPER()          Convert lowercase characters to uppercase 
 + USED()          Determine whether a database file is in USE 
 + VAL()            Convert a character number to numeric type 
 + VALTYPE()        Determine the data type returned by an expression 
 + VERSION()        Returns CA-Clipper version 
 + WORD()* Convert CALL command numeric parameters from double to int 
 + YEAR()          Convert a date value to the year as a numeric value 
 +</code>
 

Link categories 1

Link categories 2