home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a087 / 6.ddi / CUSTOMER.QP_ / CUSTOMER.bin
Encoding:
Text File  |  1994-02-02  |  1.2 KB  |  28 lines
  1.  
  2. * WIZNAME = WZ_BQUER
  3. * VERSION = .72
  4. * TIMESTAMP= 473918752.0000
  5. * CLIENTSERVER =
  6. * TABLES = "C:\FPW26\SAMPLE\CATALOG\CUSTOMER.DBF";"C:\FPW26\SAMPLE\CATALOG\SALESMAN.DBF"
  7. * JOINS = Salesman,"Address",Customer,"Address",1
  8. * FIELDS = Salesman.name;Customer.company;Customer.address;Customer.city;Customer.state
  9. * SORT FIELDS = Customer.company
  10. * GROUP = Customer.ytdpurch:5N
  11. * SQL = SQL Select statement for Mailmerge Wizard:
  12. *SELECT Salesman.name,Customer.company,Customer.address,Customer.city,Customer.state,;
  13. *        INT(Customer.ytdpurch/10000) * 10000 AS GRP1 ;
  14. *    FROM ;
  15. *         C:\FPW26\SAMPLE\CATALOG\CUSTOMER.DBF,C:\FPW26\SAMPLE\CATALOG\SALESMAN.DBF;
  16. *    WHERE Customer.Address=Salesman.Address;
  17. *    ORDER BY Customer.company;
  18. *    GROUP BY GRP1;
  19. *    INTO CURSOR Query
  20. SELECT Salesman.name,Customer.company,Customer.address,Customer.city,Customer.state,;
  21.         INT(Customer.ytdpurch/10000) * 10000 AS GRP1 ;
  22.     FROM ;
  23.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\CUSTOMER.DBF","DBF","Where is Customer.DBF ?"),;
  24.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\SALESMAN.DBF","DBF","Where is Salesman.DBF ?");
  25.     WHERE Customer.Address=Salesman.Address;
  26.     ORDER BY Customer.company;
  27.     GROUP BY GRP1;
  28.     INTO CURSOR Query