| Subject | Re: [IBO] Query no longer works after upgrading |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-04-19T01:22:27Z |
At 06:06 PM 18/04/2005 -0700, you wrote:
1) Did you also recently upgrade from something lower down the chain to
Firebird 1.5? (This isn't a valid statement in 1.5 because of
inconsistencies in the column qualifiers...)
2) What indication do you have that "it no longer
works"? (Exception? which one? at what point?)
Helen
>Greetings,More info required:
>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?
1) Did you also recently upgrade from something lower down the chain to
Firebird 1.5? (This isn't a valid statement in 1.5 because of
inconsistencies in the column qualifiers...)
2) What indication do you have that "it no longer
works"? (Exception? which one? at what point?)
Helen