Greetings,
I've recently upgraded from V4.2G to 4.5B and the following query no longer
works:

INSERT INTO PI_INQ (
USERID, COMPANY, DIVISION, INVLOC, PRODID,
WRAPCODE, SALESID, YARDLOC, INBORDERNO, INBSUFFIX, MILLNO, SPIECES,
SFOOTAGE, TOTCOST, WOODCOST, FRTCOST, PROCESSCOST, INTEREST
)
SELECT
:USERID, COMPANY, DIVISION, INVLOC, S.PRODID,
S.WRAPCODE, S.SALESID, S.YARDLOC, S.INBORDERNO, S.INBSUFFIX, 0, S.PIECES,
S.FOOTAGE, ( S.WOODCOST+S.FRTCOST+S.PROCESSCOST+S.INTEREST ), WOODCOST,
FRTCOST, PROCESSCOST, INTEREST
FROM PI_SUM S
LEFT OUTER JOIN PROD_XREF X ON S.PRODID = X.PRODID
WHERE
S.COMPANY = :COMPANY AND S.DIVISION = :DIVISION AND S.INVLOC = :INVLOC



Is this by design?

Thanks,
Kevin