Subject RE: [IBO] Query no longer works after upgrading
Author Kevin Stanton
Hi Helen,

This query populates on-hand inventory into PI_INQ. After upgrading to IBO
4.5B, the on-hand numbers were no longer inserted.

After some testing (took a while to figure out), I found replacing :USERID
with 'KEVIN' (or the literal name of the user logged in to my app), my
on-hand numbers came back.

I have not upgraded databases, currently using FB 1.03 but am gearing up to
move to 1.5.

Kevin





_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Helen Borrie
Sent: Monday, April 18, 2005 6:22 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Query no longer works after upgrading



At 06:06 PM 18/04/2005 -0700, you wrote:

>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?

More info required:

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




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !




_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]