I have a query that joins several tables. It runs fine under FPW26a.
I would like to recompile it with VFP5 because I would like the XL5
output.

When I run the same prg compiled in VFP5 (same dir, same tables) it creates a temp file larger than 2 gigs, consumes all the memory and falls over.

The client has VFP5 not sure if I can get them to upgrade.

Does anyone know why a query that works in 26a won't work in VFP5?

Thanks,
Rich Wartner


SELECT xloadout.STATUS AS GEO,;
SPACE(1) AS RCV,;
xloadout.ZZ_STORENA AS STORENAME,;
IIF(EMPTY(xloadout.ZZ_STARCAP),xcust.ZZ_STARCAP,xloadout.ZZ_STARCAP) AS Proj_No,;
xloadout.PURCHORD AS Store_No,;
SPACE(1) AS TRUE_BO,;
xloadout.SALESORD AS BOOKING,;
xloadout.DATE AS SHIPDATE,;
xloadout.HODATE AS REQ_DATE,;
xloadout.HObatch AS REQ_batch,;
IIF(EMPTY(xinv_trn.bsm),"N","Y") AS assigned,;
xinv_mst.code2 AS SKU,;
xcode2.DESCRIP AS DESCRIPT,;
xloadout.DATE AS FSTBODATE,;
SUM(xinv_trn.QTY) AS QTY,;
SUM(xinv_trn.QTY) AS ONHAND,;
SUM(xinv_trn.QTY) AS HARDALLOC,;
SUM(xinv_trn.QTY) AS TOTBOPQTY,;
xloadout.BATCH AS MCDSBATCH,;
xloadout.CUSTCODE AS Wrhs;
FROM xloadout,xinv_trn,xinv_mst,xcust,xcode2 ;
WHERE xloadout.BATCH = xinv_trn.BATCH;
AND xloadout.CONSCODE = xcust.CUSTCODE;
AND xinv_trn.BSM = xinv_mst.BATCH + xinv_mst.SEQUENCE;
AND xinv_mst.CUSTCODE + xinv_mst.CODE1 + xinv_mst.code2 = xcode2.CUSTCODE + xcode2.CODE1 + xcode2.code2;
AND xloadout.HODATE <= (ld_sdate);
GROUP BY xloadout.CUSTCODE,xcust.ZZ_STARCAP,xloadout.BATCH,SHIPDATE,xinv_mst.code2,assigned;
INTO TABLE final