Field Manipulation Language

Article
06/18/2008

These commands and functions make it possible for you to manipulate fields in a table.

Use	To
AFIELDS( ) Function	Store information about the structure of the current table into an array and return the number of fields.
BLANK Command	Clear data from the specified fields.
DELETED( ) Function	Indicate if a record is marked for deletion.
FCOUNT( ) Function	Return the number of fields in a table.
FIELD( ) Function	Return the name of a field, reference by number.
FLDLIST( ) Function	Included for compatibility with dBASE.
FSIZE( ) Function	Return the size in bytes of a specified field or file.
GATHER Command	Replace the data in a record with data from a specified source.
ISBLANK( ) Function	Determine whether an expression is blank.
LUPDATE( ) Function	Return the date on which a table was last updated.
NDX( ) Function	Return the name of an open index (.IDX) file for the current or specified table.
SCATTER Command	Copy data from a record into a specified target.
SET BLOCKSIZE Command	Specify how to allocate disk space for memo field storage.
SET EXACT Command	Specify the rules to compare two strings of different lengths.
SET NOCPTRANS Command	Prevent translation to a different code page for selected fields in an open table.
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 text-merge delimiters.
SYS(14) - Index Expression	Return index expression of an open single-entry .idx index file or index expressions for tags in compound .cdx index files.

See Also

Other Resources

Language Categories