Tutorial by Examples

/* Define a query named q1 for the Customer table */ DEFINE QUERY q1 FOR Customer. /* Open the query for all Customer records where the state is "tx" */ OPEN QUERY q1 FOR EACH Customer WHERE Customer.state ='TX'. ...

This query will join three tables: Customer, Order and Orderline. The use of the OF statement as in childtable OF parenttable assumes that indexes are constructed in a specific way. That is the case in the sports2000-database. DEFINE QUERY q1 FOR Customer, Order, Orderline. OPEN QUERY q1 FOR EA...

DEFINE QUERY q1 FOR Customer. OPEN QUERY q1 FOR EACH Customer. GET FIRST q1. loop: REPEAT: IF AVAILABLE Customer THEN DO: DISPLAY Customer.NAME CustNum WITH FRAME frClient TITLE "Client data". DISPLAY "(P)revious" SKIP ...