Table_Set_Name

The name of the table or set to display.

Filter

Optional. Default = .T. (all records). A character filter expression that evaluates to a logical value. Selects records from the table.

Order

Optional. Default = record order. A character order expression that sorts selected records.

Description

The description that you assign to the query that Alpha Five creates when the form is opened.

Options

Optional. Default = Record order, ascending, not unique. Controls whether Alpha Five uses an index, a new query list, or an existing query list to satisfy a query. This string can contain one or more of the following codes:

N

Builds a query list even if an index matches the query definition.

D

The descending order option puts the records in descending alphabetical order or, for a numeric field, from highest to lowest value.

T

Temporary query. Alpha Five will automatically delete this query if necessary if building a new query would cause it to run out of query slots. there are a maximum of 16 query slots.

U

The unique option includes only unique records in the query list.

M

Builds a new query list even though a) an existing query list exists, and b) an existing Index exists (both of which, Alpha Five could have used rather than running a new query).

X

Use an index even if an existing query exists (which Alpha Five would otherwise have used in preference to the index).

I

The I flag is obsolete. It was used by Alpha Five V1 to indicate that the index should be case-insensitive. However since V2, Alpha Five automatically builds all indexes as Case-insensitive. It is documented because in some situations, the Script Recorder will show Xbasic code that includes the "I" flag.

Show_All

Optional. Default = .F. Specifies whether the Show All icon that appears on the toolbar is enabled.

• .T. = Icon enabled.

• .F. = Icon not enabled.