The Aeries™ Query option is used to create a query statement that will access data stored within tables (files) in the Aeries™ database. Once the query statement is processed certain data can be used to create a report, labels, envelopes, etc. or to update specific data.
Click the mouse on any area of Aeries™ Query form to display detailed information.
Aeries™ Query Language has a very simple format demonstrated in the following examples:
Display all student data.
LIST STU
Display student’s last name, first name, grade, sex.
LIST STU LN FN GR SX
Display same information sorted by grade level.
LIST STU LN FN GR SX BY GR
Display same information but for only females.
LIST STU LN FN GR SX BY GR IF SX = F
QUERY uses three letter codes for tables, for example, STU, TCH, etc. and up to three letter codes for fields, for example, LN, FN, GR, SX. One purpose of the QUERY form is to give the user a quick listing of available tables and within each table, a listing of the fields and what they contain.