Share via

Field Manipulation Language

  • Article

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

Databases

Language Categories