Click above to get retro games delivered to your door ever month!

Syntax

Q_OPTIMIZE( xcQuery_str[, cQindex [, cQkey ]] )

Purpose

Set or undo an optimised filter on one or more tables. Called by QUERY().

Arguments

     xcQuery_str -- filter to set (passed as a character expression to be
                    macro-expanded) or null string to undo

     cQindex -- name of index to create; defaults to left 6 characters of
                the alias of the current table. "_Q" is append to this if
                single user, or a unique name if multi-user.

     cQkey -- is passed, index key to use, else INDEXKEY(0 ).

Setup

Query filters are held in the public array aafilter[]. If Q_OPTIMIZE() in
not called from THE_USUAL(), you must call INIT_QUERY() first.

The conditional index is based on the xcQuery_str and the controlling index,
which must be character-based.

Example

     USE CUSTOMER INDEX CUSTOME1
     INIT_QUERY()
     Q_OPTIMIZE( "Balance > 5" )
     TBROWSER()

Returns

.T. if successful in setting/removing query, else .F.

Side Effects

All those of setting/removing a filter.

Artful Calls

FILTR_TYPE, POP_MSG, IS_OPEN, DICTFIND, XCOUNT, STRINT, SET_INDEX

Source File

AA_FILTR.PRG, AM_FILTR.PRG