Xbasic

Set Functions

Description

Alpha Anywhere provides the following Set functions.

Name
Description
A5_DUPLICATE_SET Function

Displays the Duplicate Set dialog box.

A5_DUPLICATE_SET_FILES Function

Creates a duplicate of a set

a5_get_level_name Function

Returns the level in the set at which the alias_name exists.

a5_is_passivelinkset Function

Returns .t. if any table in the set is a passive-link table.

a5_must_flatten_query Function

Returns .t. if a filter on a set needs to use the flattenquery() command

a5_new_set Function

Create a new Set

A5_PACK_SET Function

Packs the records in the tables of a set. Prompt for tablenames if silent if .f.

a5_repair_set_structure Function

Repair the structure of a set if one or more of the tables in the set have been moved to different locations.

A5_RepairSetStructure Function

Displays the Fix Table Name in Set dialog.

a5_set_editor2 Function

Modal set editor.

a5_set_editor_toolbar Function

Returns the system toolbar for Set Editor

a5_set_in_use Function

Returns .t. if the specified set is currently open.

A5_SETS_ENUM Function

Returns a list of table names. If table name is not unique it is fully qualified, otherwise not.

a5_show_set_info Function

Show information about a set's structure

a5_undelete_set Function

Packs the records in the tables of a set. Prompt for tablenames if silent if .f.

A5_ZAP_SET Function

Packs the records in the tables of a set. Prompt for tablenames if silent if .f.

FILES_IN_SET Function

Returns a crlf delimited string of files in a set. Options "d" - include Dictionary, "x" - include Indexes

LINK Function

Returns the linking key given the name of a child table.

LIST_FILES_IN_SET Function

Returns a CRLF delimited list of all physical files in a set.

MRECNO Function

Returns composite record number when printed.

SCANNING Function

Returns TRUE if the supplied child table is being fetched through.

TABLES_IN_SET Function

Returns a crlf delimited string of tables in a set,