Subject Query no longer works after upgrading - resend
Author Kevin Stanton
<sorry - hit the send btn too soon>

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


When I remove the :USERID param and programmatically replace it with
'KEVIN', the query then works.

Is this my problem or IBO's?

Thanks,
Kevin