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 stokisueVFP 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 stokisueNote 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).