> SELECT DISTINCT ; > piitems.clstkno , ; > pireq.creqno , pireq.cacccode, pireq.dreqdate, ; > piitems.cuomissu , piitems.nreqqty , ; > instock.cdescript , ; > ALLTRIM(accounts.camfname) AS 'camfname' , ; > ALLTRIM(accounts.camlname) AS 'camlname' ; > FROM pireq , piitems , instock , accounts ; > ORDER BY piitems.clstkno, pireq.creqno , pireq.dreqdate ; > WHERE pireq.creqno = piitems.creqno ; > AND BETWEEN(pireq.dreqdate , m.dstartdate , m.denddate ) ; > AND ALLTRIM(piitems.clstkno) = ALLTRIM(instock.cstkno) ; > AND piitems.csitecode = gcsitecode ; > AND pireq.cacccode = accounts.cacccode ; > &lcfor ; > INTO CURSOR stokisue >>VFP 9 code
> SELECT DISTINCT ; > piitems.clstkno , ; > pireq.creqno , pireq.cacccode, pireq.dreqdate, ; > piitems.cuomissu , piitems.nreqqty , ; > instock.cdescript , ; > ALLTRIM(accounts.camfname) AS 'camfname' , ; > ALLTRIM(accounts.camlname) AS 'camlname' ; > FROM pireq , piitems , instock , accounts ; > ORDER BY piitems.clstkno, pireq.creqno , pireq.dreqdate ; > WHERE pireq.creqno = piitems.creqno ; > AND BETWEEN(pireq.dreqdate , m.dstartdate , m.denddate ) ; > AND ALLTRIM(piitems.clstkno) = ALLTRIM(instock.cstkno) ; > AND pireq.csitecode = gcsitecode ; > AND piitems.csitecode = gcsitecode ; > AND pireq.cacccode = accounts.cacccode ; > &lcfor ; > INTO CURSOR stokisue >>Note addition selection criteria for additional field in pireq table AND pireq.csitecode = gcsitecode ;. In this case
&lcforis a blank.
SELECTif possible, or put in a progress bar if possible (P.S. FWIW I am using SDT).