课本回顾（Textbook review）.docVIP

课本回顾（Textbook review） 2, basic operation questions (30) 3, simple application (40) 4, comprehensive operation (30) 5, written examination questions Two hundred and fifty-two million seven hundred and eleven thousand one hundred and sixty-three 1, table establishment Create table Modify table structure Location command (three types) (LOCATE, FOR,..CONTINUE) Append record 2, table operation Display table contents Delete tables, records DELETE, ALL, and PACK==ZAP Modify table record (REPLACE, WITH) The sorting table records the establishment of the index (INDEX, ON, index, expression, TAG, index name) Structured composite index (extension.CDX) Single index file (extension.IDX) Copy table record and structure 3, other data outside the table Constant: Note: when writing constants, delimit the corresponding delimiter Xian World Horticultural Exposition [Xian] [Hello] Hello! Variable: Note: 1. Access to field variables and memory variables of the same name When a field variable is the same as a memory variable, the system defaults to access to a field variable; to access memory variables, you must add M. or M- before the variable 2 、 the difference between an array and a simple memory variable 1. arrays need to be defined before they are used After the 2. array is defined, the system gives each element the default logical false value (.F.) Expression： Note: 1, the arithmetic of character expressions 2, the operation rules of the date expression DATE () +{^2000/12/12} 12+{^2000/12/12} 12-{^2000/12/12} DATE () -{^2000/12/12} An operation that cannot be performed: date + date Days - date Computer $computer Function: Note: 1, numerical functions (for integers and residue functions) 2, character function (remove the space and praying before and after the string function) (for length, return space, character matching) 3, date and time function (return date and time of the system, year in the return date) 4, data type conversion (value and character conversion) 5, test function (