home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a087 / 6.ddi / CUSTORDR.QP_ / CUSTORDR.bin
Encoding:
Text File  |  1994-02-02  |  1.3 KB  |  30 lines
  1.  
  2. * WIZNAME = WZ_BQUER
  3. * VERSION = .62
  4. * TIMESTAMP= 474064347.0000
  5. * TABLES = "C:\FPW26\SAMPLE\CATALOG\CUSTOMER.DBF";"C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF"
  6. * JOINS = Invoices,"Cno",Customer,"Cno",1
  7. * FIELDS = Customer.company;Customer.city;Customer.state;Customer.zip;ORDERS=COUNT(Invoices.ino);TOTALSALES=SUM(Invoices.itotal)
  8. * SORT FIELDS = Customer.company
  9. * GROUP = Customer.company:1C
  10. *    SQL Select statement for Mailmerge Wizard:
  11. *SELECT Customer.company,Customer.city,Customer.state,Customer.zip,;
  12.         COUNT(Invoices.ino) AS ORDERS,;
  13.         SUM(Invoices.itotal) AS TOTALSALES ;
  14. *    FROM ;
  15. *         LOCFILE("C:\FPW26\SAMPLE\CATALOG\CUSTOMER.DBF","DBF","Where is Customer.DBF ?"),;
  16. *        LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?");
  17. *    WHERE Customer.Cno=Invoices.Cno;
  18. *    ORDER BY Customer.company;
  19. *    GROUP BY Customer.company;
  20. *    INTO CURSOR Query
  21. SELECT Customer.company,Customer.city,Customer.state,Customer.zip,;
  22.         COUNT(Invoices.ino) AS ORDERS,;
  23.         SUM(Invoices.itotal) AS TOTALSALES ;
  24.     FROM ;
  25.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\CUSTOMER.DBF","DBF","Where is Customer.DBF ?"),;
  26.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?");
  27.     WHERE Customer.Cno=Invoices.Cno;
  28.     ORDER BY Customer.company;
  29.     GROUP BY Customer.company;
  30.     INTO CURSOR Query