home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a087 / 6.ddi / PARTS90.QP_ / PARTS90.bin
Encoding:
Text File  |  1994-02-02  |  1.6 KB  |  37 lines
  1.  
  2. * WIZNAME = WZ_BQUER
  3. * VERSION = .62
  4. * TIMESTAMP= 474063088.0000
  5. * TABLES = "C:\FPW26\SAMPLE\CATALOG\PARTS.DBF";"C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF";"C:\FPW26\SAMPLE\CATALOG\DETAIL.DBF"
  6. * JOINS = Invoices,"Ino",Detail,"Ino",1
  7. * JOINS = Detail,"Pno",Parts,"Pno",1
  8. * FIELDS = Parts.pno;Parts.descript;TOTALSALES=SUM(Detail.price);TOTALQTY=SUM(Detail.qty)
  9. * FILTER = 0,0,"Invoices.idate",5,"1/1/1990",0
  10. * FILTER = 0,0,"Invoices.idate",3,"12/31/1990",0
  11. * SORT FIELDS = Parts.pno
  12. * GROUP = Parts.pno:1C
  13. *    SQL Select statement for Mailmerge Wizard:
  14. *SELECT Parts.pno,Parts.descript,;
  15.         SUM(Detail.price) AS TOTALSALES,;
  16.         SUM(Detail.qty) AS TOTALQTY ;
  17. *    FROM ;
  18. *         LOCFILE("C:\FPW26\SAMPLE\CATALOG\PARTS.DBF","DBF","Where is Parts.DBF ?"),;
  19. *        LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?"),;
  20. *        LOCFILE("C:\FPW26\SAMPLE\CATALOG\DETAIL.DBF","DBF","Where is Detail.DBF ?");
  21. *    WHERE Detail.Ino=Invoices.Ino AND Parts.Pno=Detail.Pno;
  22. *    AND (Invoices.idate>={1/1/1990}.AND.Invoices.idate<={12/31/1990});
  23. *    ORDER BY Parts.pno;
  24. *    GROUP BY Parts.pno;
  25. *    INTO CURSOR Query
  26. SELECT Parts.pno,Parts.descript,;
  27.         SUM(Detail.price) AS TOTALSALES,;
  28.         SUM(Detail.qty) AS TOTALQTY ;
  29.     FROM ;
  30.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\PARTS.DBF","DBF","Where is Parts.DBF ?"),;
  31.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\INVOICES.DBF","DBF","Where is Invoices.DBF ?"),;
  32.          LOCFILE("C:\FPW26\SAMPLE\CATALOG\DETAIL.DBF","DBF","Where is Detail.DBF ?");
  33.     WHERE Detail.Ino=Invoices.Ino AND Parts.Pno=Detail.Pno;
  34.     AND (Invoices.idate>={1/1/1990}.AND.Invoices.idate<={12/31/1990});
  35.     ORDER BY Parts.pno;
  36.     GROUP BY Parts.pno;
  37.     INTO CURSOR Query