Variable Manipulation
These commands and functions make it possible for you to assign values to variables or text.
Use |
To |
|---|---|
Perform macro substitution. |
|
Evaluate one or more expressions. |
|
Copy elements from one array to another array. |
|
Delete an element from a one-dimensional array, or a row or column from a two-dimensional array. |
|
Place information about files into an array and then return the number of files. |
|
Return the number of an array element from the element's subscripts. |
|
Retrieve and stores information about the structure of the table in a specified work area, specified by a table alias, or in the currently selected work area in an array and return the number of fields in the table. |
|
Insert an element into a one-dimensional array, or a row or column into a two-dimensional array. |
|
Search an array for an element containing the same data and data type as an expression. |
|
Sort elements in an array in ascending or descending order. |
|
Return the row or column subscript of an element from the element's number. |
|
Compute the arithmetic mean of numeric expressions or fields. |
|
Release the specified item or items from memory. |
|
Release the specified item or items from memory. |
|
Count table records. |
|
Display the current contents of variables and arrays. |
|
Display the Expression Builder Dialog Box so you can create an expression and store the expression to a variable or array element. |
|
Specify the program that is executed when you issue the GETEXPR command or invoke the Expression Builder dialog box from within Visual FoxPro. |
|
Determine the number of characters in a character expression, indicating the length of the expression. |
|
Display table or environment information without pausing the main Visual FoxPro or user-defined window. |
|
Create local variables and variable arrays. |
|
Assign data from a calling program to private variables or arrays. |
|
Hide specified variables or arrays that were defined in a calling program from the current program. |
|
Define global variables or arrays. |
|
Remove variables and arrays from memory. |
|
Retrieve variables and variable arrays saved in a variable file or a memo field and places them into memory. |
|
Store current variables and arrays to a variable file or memo field. |
|
Store data to a variable, to an array, or to an array element. |
|
Total all or specified numeric fields in the currently selected table. |
|
Provide evaluation of a character expression. |
|
Display a message and pause Visual FoxPro execution until the user presses a key or clicks the mouse. |