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

Syntax

QUERY( [ cTable[, nRow[, nCol ]]] )

Purpose

A generalised relational query module. Link into any application.

Arguments

     cTable -- if passed, alias of table to use; defaults to current one

     nRow -- top row of query window; defaults to 2

     nCol -- left coloumn of query window; defaults to 10

Setup

cTable, SYS and the UQUERY table must be open. Queries are stored in UQUERY
(USERQRY.DBF in AAI). For the structure of this table, see QUERIES.

UQUERY is indexed on UPPER( Data_file + Query_name ).

Example

In an application designed around Artful, QUERY() is automatically included,
with all its support requirements.

To create a stand-alone call to QUERY() for use in an existing application...

     SYSCOLOR( 1 )
     CLEAR SCREEN
     SELECT 0
     USE SYS
     SELECT 0
     USE userqry ALIAS Uquery INDEX userqry1
     SELECT 0
     USE orders INDEX orders1
     SELECT 0
     USE customer
     SET RELATION TO Account_no INTO orders
     QUERY()
     ? GET_FILTER()

Returns

.T.

Side Effects

SETS FILTER TO the conditions you specify, or, if query optimisation is on,
makes a conditional index. Control is returned to the caller with the query
in place.

Artful Calls

FILTR_TYPE, PULL_OPEN, IS_DATA, SYSCOLOR, GET/SET_KEYS, STAT_LINE,
GET/SET_FILTER, VERIFY, POP_MSG, PUSH/POP_SCR, AEMPTY, HEADERS, DRAW_BOX,
BLANK, READ_IT, GEN_PIC, READ_MEMO, ASK_FOR, UNIQUE, YESNO, HELP_FILL,
GET_ALIAS, QUERYNAME, INIT_QUERY

QUERY() also calls a number of internal functions not documented here:
GET_FIELD(), GET_CLAUSE(), GET_OP(), GET_VALUE(), ANDORDUN(), QPROCESS(),
QPO_UDF(), SET_QTYPE(), QCREATE(), QEXPERT(), QEDIT(), QUNDO(), QREAD(),
QSAVE().

Source Files

AA_QUERY.PRG, AM_QUERY.PRG