#VISUAL FOXPRO COMMANDS AND FUNCTIONS CODE#
#VISUAL FOXPRO COMMANDS AND FUNCTIONS SERIES#

#VISUAL FOXPRO COMMANDS AND FUNCTIONS CODE#

ASC( ): This function returns the ASCII code of the character expression.Д®xample: ?ASC(вЂњAвЂќ) Will display: 65ДҐ. ALLTRIM( ): This function remove the leading and trailing blank spaces of both side from a character expression. RTRIM( ): This function remove the leading and trailing blank spaces of Right side from a character expression. LTRIM( ): This function remove the leading and trailing blank spaces of left side from a character expression. This functions are tools that let you control the way you can store or display strings.ДЎ.

#VISUAL FOXPRO COMMANDS AND FUNCTIONS SERIES#

String Function: A string is a series of character and spaces which are numeric, character or logical. ?вЂќToday date is :-вЂќ+DTOC(D) Will display: Today date is :-Д¬. CDOW( ): This function returns the day of the week in text form.Д®xample: ?CDOW() Will Display: Independence day is :. Date & Time Function: This functions are convenient for displaying or printing the current time & date on reports.ДЎ. VAL( ): This function returns a numeric value from character string expression.Д®xample: ?VAL(вЂњ12AB13cD14вЂі) Will display: 12.00Д«. SQRT( ): This function returns square root valueД®xample: ?SQRT(64) Will display: 8.00ДЁ. ROUND( ): This function returns round number with specified number of decimal place.Д®xample: ?ROUND(123.456,2) Will display: 123.46 MOD( ): This function returns the remainder value from a division problem.Д®xample: ?MOD(15,3) Will display: 0Д¦. MIN( ): This function returns the lowest value of the numeric expressions.Д®xample: ?MIN(12,45,78,33) Will display: 12ДҐ.

MAX( ): This function returns the highest value of the numeric expressions.Д®xample: ?MAX(12,45,78,33) Will display: 78Д¤. INT( ): This function evaluates the numeric argument and returns the integer part of the numeric expression.Д®xample: ?INT(123.456) Will display: 123ДЈ. ABS( ): This function returns the absolute value of the numeric expression.Д®xample: A=12 B=22 ?ABS(A-B) Will display: 10Дў. Numeric Function: User can use the following numeric function on numeric data or to returns numeric data.ДЎ. To display the result of function, use вЂњ?вЂќ (Print) sign before the function in Visual FoxPro command window.ДЄ. The expression usually contain the value of a field or memory variable.Дifferent type of Visual FoxPro Function: There are Three types of Function. A function is built in feature that returns a predefined or performs some operation on data and returns the result in the specified form.

Visual foxpro commands and functions