Subject | Query no longer works after upgrading - resend |
---|---|
Author | Kevin Stanton |
Post date | 2005-04-19T01:15:19Z |
<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
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