Query Methods

Description

Alpha Anywhere provides the following Query methods.

Discussion

A query is different from an index. Alpha Anywhere automatically synchronizes an index with table data. A query is static and must be deliberately refreshed to reflect table changes. Precede each method with the <Query> pointer produced by <TBL>.QUERY_CREATE().

Methods

QUERY.DELETE Method

The QUERY.DELETE() method displays a confirmation dialog, then deletes a saved query.

QUERY.DROP Method

The .DROP() method deletes the query list file ($$*.MPX) referenced by the object pointer.

QUERY.FETCH_STATE_LIST_GET Method

The .FETCH_STATE_LIST_GET() method returns a list of fetch states from head or tail of a query list (direction depends on +/- records).

QUERY.FILENAME_GET Method

The .FILENAME_GET() method returns the full Filename, including drive and path of the query file referenced by the pointer.

QUERY.FILTER_GET Method

The .FILTER_GET() method returns the Filter (a logical expression ) for the query list.

QUERY.FIND Method

The .FIND() method finds a value in the query list and returns a pointer to the Key_Value found. The key has two properties: key and record, as illustrated below.

QUERY.FIND_FIRST Method

The .FIND_FIRST() method returns a pointer to the first key value.

QUERY.FIND_LAST Method

The .FIND_LAST() method returns the last key value.

QUERY.FIND_NEXT Method

Repeats Find_by_Form, finding the next record.

QUERY.FIND_PREVIOUS Method

The .FIND_PREVIOUS() method finds the key before the specified key.

QUERY.FLAGS_GET Method

Returns the query options for the query list.

QUERY.ORDER_GET Method

The .ORDER_GET() method returns the order expression for the query list.

QUERY.RECNO_LIST_GET Method

Retrieves Count record numbers from the query list.

QUERY.RECORDS_GET Method

The .RECORDS_GET() method retrieves the Number_of_Records selected by the query list.

QUERY.REFRESH Method

Force repaint of control.

QUERY.TABLE_GET Method

Get the table associated with an object.

QUERY.TYPE_GET Method

Returns the type of the index referenced by the object pointer.