Numerical function: 1. The absolute value and symbol function format: ABS (u003Cnumerical expression>) SIGN 5, ABS (4) = 4, sign (8) = 1, sign (-3) = -1, sign (0) = 0 2. Find a square expression Format: SQRT (u003Cvalue Expression>) For example: SQRT (16) = 4, it is equivalent to one -half of them. 3. Pay rate function Format: Pi () 4. Find an integer function Format: int (u003CNumeral expression>) Return the integer part of the value expression CEILING u003CNumeric expression>) Returns the minimum integer larger than or equal to the expression floor (u003CNumeric expression>) to return to the maximum integer that is less than or equal to the expression for example: int (5.8) = 5.8 , Int (-7.8) = -7, CEILING (6.4) = 7, Ceiling (-5.9) = -5 floor (9.9) = 9 5. Numerical expression 1>, u003CNumeric expression 2>) Function: Return to the results of formulating expressions in the formulation of four houses , for example: Round (345.345,2) = 345.35, Round (345.345,1) = 345.3, Round (345.345,0) = 345, round (345.345, -1) = 350 6. Find the remaining function format Formula 2>) For example: mod (10,3) = 1 MOD (10, -3) = -2 mod (-10,3) = 2 MOD (-10, -3) =- 1 The law of the remaining numbers: 1. Find the remaining value according to the absolute value of the two numbers 2. The absolute value of expression 1 is greater than the absolute value of expression 2, the remaining number is the value of expression 1 3. The remaining number of the remaining expression 1 4. If the two counts are good, the remaining number is the final result of the expression 2 Value function max (numerical expression list) min (numerical expression list) for example: max (2,3,5) = 5 max („2‟, ‟12‟, ‟05 X) = 2 Max („„ ‟,‟ airplane ‟,‟ ship ‟) The rules of comparison of string: Character string compare the first letter first, if there is a result, then do not need to be performed by the result. Compared. If the comparison of the second letter is equal, the secondary category is pushed. Character function 1. Find the length function of the string Format: Len (u003Ccharacter expression>) function: return to the length of the character expression, that is, the characters contained in number. The function value is numerical type . For example: x = "Chinese Visual FoxPro6.0", LEN (x) = 20 2. upper (u003Ccharacter expression>) function: LOWER converts the capital letters in the expression value into a lowercase letter, other characters remain unchanged upper Become a capital letter, other characters remain unchanged. , for example: LOWER („x1y2a‟) = x1y2a upper („n = 1‟) = n = 1 3. Function: Returns the string composed of spaces with a specified paragraph. 4. Delete the front and rear space function format: Trim (u003Ccharacter expression>) Ltrim : Trim (): Returns the string formed by the specified character expression value after removing the tail space ltrim (): Return the specified character expression value to remove the string formed by the previous guide space allTrim (): Return to the specified character The expression value removed the string formed after the front -guide space and the tail space. , for example: Store space (1) "test" space (3) to ss ? Trim (ss) LTRIM (ss) allTrim (ss) LEN (ss) = 8 , Len (Trim (SS)) = 5, Len (LTRIM (SS)) = 7, Len (ALLTRIM (SS)) = 4 5. Formula>, u003CLevel>) Right (u003Ccharacter expression>, u003Cquiferous>) substr (u003Ccharacter expression>, u003Cstarting position>, u003Clength>) for example: store ‟-123. To X, Stort„ 45 ‟to y store‟ A45 ‟to z 0val (x y) = 123.45, value (x z) = 123.00, value (z y) = 0.00 3. The string is converted to date or date format: CTOD (u003Ccharacter expression>) converted to date data CTOT (u003Ccharacter expression>) converted to date time type Data 4. Date or date convert into string Formats: DTOC (u003CDate Expressive> | u003CDate Time Expression> [, 1]) ttoc (u003CDate time expression> [, 1]) The function TOC () The date part of the date data or date time data is partially converted into string ttoc () to convert the date time data into string Statement: For DTOC () For example, if the option is 1, the format of the string is always yyyymmdd, 8 characters. For TTOC (), if used option 1, the string format is always, 14 characters for example: store datetime () to t dtoc (t) = 11/11/2005 , DTOC (T, 1) = 20051111, ttoc (t) = 11/11/2005 18:54:34 pm ttoc (t, 1) = 5 macro replace function format:

The function of the function or type conversion in the program plays a certain role in the program. Let me classify some commonly used functions. (1) Numerous function: The calculation result is numerical type. Common ones are abs absolute value function sqrt square root functions int to take the entire function, only the combined digit is given to the decimal bit icing back to the minimum integer greater than or equal to the specified value expression FLOWER returns the maximum integer that is less than or or equal to specified the specified value expression round four houses and five in -five functions, and returns the result of the specified value expression at the specified position. The negative sign is consistent with the division max calculate the value in each expression, and returns the maximum value min to calculate the value in each expression. Returns the minimum value (2) character function: The operation result is the character type. The common ones are len return to the length of the specified character expression value. In the bytes, a Western character or space accounts for a character, a Chinese character accounts for two character functions to numerical type r r lower, UPPER converts the specified character expression into uppercase and lowercase letters, respectively. Other characters remain unchanged sapce return to the string of the specified number of spaces trim, ltrim, alltrim back to the specified character expression and remove The string formed by the rear, first, first, and tail spaces left, and right takes a sub -skewers with a specified length from the left end and right end of the specified expression value as the function value substr from the specified position of the specified expression value to take. Specify the sub -string of length as a function at, ATC If the front string is the sub -string of the rear string, test the position of the first character in the string in the posterior string, Numerical type, ATC does not distinguish between letters and lowercases in the test stuff from the specified position of the previous character string to specify the character with the post -string replaced like comparison The characters are matched, the function The return value is logical, otherwise it is logical false. The front string can contain the dated (3) date and time function date Return the current system date, the function value is date type time returns the current system time in the 24 -hour, HH: MM: SS format, and the function value is character type dateTime back to the current system date time. The date or date of the date or date of the return year, month, number of days hour, minute, and SEC returned from the specified date time expression to the hour, minute, second part of the number of types (4) type conversion function str value Converted into string Val string convert to value CTOD character converting to date DTOC date convert to character

LindsayNumerical function:

1. The absolute value and symbol function

format: ABS (u003Cnumerical expression>)

SIGN 5, ABS (4) = 4, sign (8) = 1, sign (-3) = -1, sign (0) = 0

2. Find a square expression

Format: SQRT (u003Cvalue Expression>)

For example: SQRT (16) = 4, it is equivalent to one -half of them.

3. Pay rate function

Format: Pi ()

4. Find an integer function

Format: int (u003CNumeral expression>) Return the integer part of the value expression

CEILING u003CNumeric expression>) Returns the minimum integer larger than or equal to the expression

floor (u003CNumeric expression>) to return to the maximum integer that is less than or equal to the expression

for example:

int (5.8) = 5.8 , Int (-7.8) = -7, CEILING (6.4) = 7, Ceiling (-5.9) = -5

floor (9.9) = 9

5. Numerical expression 1>, u003CNumeric expression 2>)

Function: Return to the results of formulating expressions in the formulation of four houses

, for example: Round (345.345,2) = 345.35, Round (345.345,1) = 345.3, Round (345.345,0) = 345,

round (345.345, -1) = 350

6. Find the remaining function

format Formula 2>)

For example:

mod (10,3) = 1 MOD (10, -3) = -2 mod (-10,3) = 2 MOD (-10, -3) =- 1

The law of the remaining numbers: 1. Find the remaining value according to the absolute value of the two numbers

2. The absolute value of expression 1 is greater than the absolute value of expression 2, the remaining number is the value of expression 1

3. The remaining number of the remaining expression 1

4. If the two counts are good, the remaining number is the final result of the expression 2 Value function

max (numerical expression list)

min (numerical expression list)

for example: max (2,3,5) = 5 max („2‟, ‟12‟, ‟05 X) = 2 Max („„ ‟,‟ airplane ‟,‟ ship ‟)

The rules of comparison of string:

Character string compare the first letter first, if there is a result, then do not need to be performed by the result. Compared. If the comparison of the second letter is equal, the secondary category is pushed.

Character function

1. Find the length function of the string

Format: Len (u003Ccharacter expression>)

function: return to the length of the character expression, that is, the characters contained in number. The function value is numerical type

. For example: x = "Chinese Visual FoxPro6.0", LEN (x) = 20

2.

upper (u003Ccharacter expression>)

function: LOWER converts the capital letters in the expression value into a lowercase letter, other characters remain unchanged

upper Become a capital letter, other characters remain unchanged.

, for example: LOWER („x1y2a‟) = x1y2a upper („n = 1‟) = n = 1

3.

Function: Returns the string composed of spaces with a specified paragraph.

4. Delete the front and rear space function

format: Trim (u003Ccharacter expression>)

Ltrim : Trim (): Returns the string formed by the specified character expression value after removing the tail space

ltrim (): Return the specified character expression value to remove the string formed by the previous guide space

allTrim (): Return to the specified character The expression value removed the string formed after the front -guide space and the tail space.

, for example: Store space (1) "test" space (3) to ss

? Trim (ss) LTRIM (ss) allTrim (ss)

LEN (ss) = 8 , Len (Trim (SS)) = 5, Len (LTRIM (SS)) = 7, Len (ALLTRIM (SS)) = 4

5. Formula>, u003CLevel>)

Right (u003Ccharacter expression>, u003Cquiferous>)

substr (u003Ccharacter expression>, u003Cstarting position>, u003Clength>)

for example: store ‟-123. To X, Stort„ 45 ‟to y

store‟ A45 ‟to z

0val (x y) = 123.45, value (x z) = 123.00, value (z y) = 0.00

3. The string is converted to date or date

format: CTOD (u003Ccharacter expression>) converted to date data

CTOT (u003Ccharacter expression>) converted to date time type Data

4. Date or date convert into string

Formats: DTOC (u003CDate Expressive> | u003CDate Time Expression> [, 1])

ttoc (u003CDate time expression> [, 1])

The function TOC () The date part of the date data or date time data is partially converted into string

ttoc () to convert the date time data into string

Statement: For DTOC () For example, if the option is 1, the format of the string is always yyyymmdd, 8 characters. For TTOC (), if used option 1, the string format is always, 14 characters

for example:

store datetime () to t

dtoc (t) = 11/11/2005 , DTOC (T, 1) = 20051111,

ttoc (t) = 11/11/2005 18:54:34 pm ttoc (t, 1) =

5 macro replace function

format:

JanieThe function of the function or type conversion in the program plays a certain role in the program. Let me classify some commonly used functions.

(1) Numerous function: The calculation result is numerical type. Common ones are

abs absolute value function

sqrt square root functions

int to take the entire function, only the combined digit is given to the decimal bit

icing back to the minimum integer greater than or equal to the specified value expression

FLOWER returns the maximum integer that is less than or or equal to specified the specified value expression

round four houses and five in -five functions, and returns the result of the specified value expression at the specified position. The negative sign is consistent with the division

max calculate the value in each expression, and returns the maximum value

min to calculate the value in each expression. Returns the minimum value (2) character function: The operation result is the character type. The common ones are

len return to the length of the specified character expression value. In the bytes, a Western character or space accounts for a

character, a Chinese character accounts for two character functions to numerical type r r

lower, UPPER converts the specified character expression into uppercase and lowercase letters, respectively. Other characters remain unchanged

sapce return to the string of the specified number of spaces

trim, ltrim, alltrim back to the specified character expression and remove The string formed by the rear, first, first, and tail spaces

left, and right takes a sub -skewers with a specified length from the left end and right end of the specified expression value as the function value

substr from the specified position of the specified expression value to take. Specify the sub -string of length as a function

at, ATC If the front string is the sub -string of the rear string, test the position of the first character in the string in the posterior string, Numerical type, ATC does not distinguish between letters and lowercases in the test

stuff from the specified position of the previous character string to specify the character with the post -string replaced

like comparison The characters are matched, the function

The return value is logical, otherwise it is logical false. The front string can contain the dated (3) date and time function

date Return the current system date, the function value is date type

time returns the current system time in the 24 -hour, HH: MM: SS format, and the function value is character type

dateTime back to the current system date time. The date or date of the date or date of the return year, month, number of days

hour, minute, and SEC returned from the specified date time expression to the hour, minute, second part of the number of types (4) type conversion function

str value Converted into string

Val string convert to value

CTOD character converting to date

DTOC date convert to character