Data Formatting Language

Article
06/24/2008

These commands and functions make it possible for you to format and display data from records, fields, memory variables, or arrays. They also make it possible for you to manipulate general screen or window display features.

Use	To
\ \| \\ Command	Print or display lines of text.
? \| ?? Command	Evaluate an expression and send the results to the main Visual FoxPro window, an active user-defined window, or the printer.
@ ... CLEAR Command	Clear a portion of the main Visual FoxPro window or a user-defined window.
@ ... FILL Command	Change the color of existing text within an area of the screen.
ACTIVATE SCREEN Command	Send all subsequent output to the main Visual FoxPro window instead of to the active user-defined window.
APPEND Command	Add one or more records to the end of a table.
BROWSE Command	Opens the browse window and displays records from a table.
CHANGE Command	Display fields for editing.
CLEAR Commands	Release specified items from memory.
CLOSE Commands	Close various file types.
CREATE FORM Command	Open the form designer.
DISPLAY Command	Display record contents and expression results for the current table.
DisplayPath( ) Function	Truncate long path expressions to a specified length for display.
EDIT Command	Display fields for editing.
FUNCTION Command	Create a user-defined function in a program file.
INKEY( ) Function	Return a number corresponding to the first mouse click or key press in the type-ahead buffer.
LIST Commands	Display table or environment information without pausing the main Visual FoxPro or user-defined window.
MESSAGEBOX( ) Function	Display a user-defined dialog box.
MODIFY FORM Command	Open the Form Designer so you can modify or create a form.
OBJTOCLIENT( ) Function	Return a position or dimension of a control or object relative to its form.
RESTORE SCREEN Command	Restore the main Visual FoxPro window or a user-defined window previously saved to the screen buffer, a variable, or an array element.
SAVE SCREEN Command	Restore the main Visual FoxPro window or a user-defined window previously saved to the screen buffer, a variable, or an array element.
SCOLS( ) Function	Return the number of columns available in the main Microsoft Visual FoxPro window.
SCROLL Command	Scroll an area of the main Visual FoxPro window or a user-defined window up, down, left, or right.
SET CARRY Command	Determine whether Visual FoxPro carries data forward from the current record to a new record created with INSERT, APPEND, and BROWSE.
SET COLOR OF SCHEME Command	Specify the colors of a color scheme or copies one color scheme to another color scheme.
SET COLOR SET Command	Load a previously defined color set.
SET CONFIRM Command	Specify whether the user can exit a text box by typing past the last character in the text box.
SET CONSOLE Command	Enable or disables output to the main Visual FoxPro window or to the active user-defined window from within programs.
SET CURSOR Command	Determine whether the insertion point is displayed when Visual FoxPro waits for input.
SET DECIMALS Command	Specify the number of decimal places displayed in numeric expressions.
SET DEVICE Command	Direct output from @ ... SAY to the screen, a printer, or a file.
SET FIXED Command	Specify if the number of decimal places used in the display of numeric data is fixed.
SET HEADINGS Command	Determine whether column headings are displayed for fields and whether file information is included when TYPE is issued to display the contents of a file.
SET MARK TO Command	Specify a delimiter for the display of date expressions.
SET MEMOWIDTH Command	Specify the displayed width of memo fields and character expressions.
SET MESSAGE Command	Define a message for display in the main Visual FoxPro window or in the graphical status bar, or specifies the location of messages for user-defined menu bars and menu commands.
SET ODOMETER Command	Specify the reporting interval of the record counter for commands that process records.
SET SPACE Command	Determine whether a space is displayed between fields or expressions when you use the ? or ?? command.
SET TEXTMERGE Command	Enable or disable the evaluation of fields, variables, array elements, functions, or expressions that are surrounded by text-merge delimiters, and specify text-merge output.
SET TEXTMERGE DELIMITERS Command	Specify the set of text-merge delimiter characters to use other than the default.
SROWS( ) Function	Return the number of rows available in the main Visual FoxPro window.
SYS(7) - Current Format File	Return the name of the current format file.
SYS(2002) - Turn Insertion Point On or Off	Turn the insertion point on or off.
TEXT ... ENDTEXT Command	Send lines of text specified by TextLines to the current output device.
TRANSFORM( ) Function	Return a character string from an expression in a format determined by a format code.

Share via

Data Formatting Language

See Also

Reference

Other Resources

Additional resources