Subject Re: [IBO] Error in statement?
Author sveinpetter@hotmail.com
Hi back, Svein Erling and Randal.

Thank you for the advices. I am well aware of the existance of
joinlinks, and I really need to kick my own butt for sticking to "ol'
fashion" linkstyles. I know you're smiling, and with good cause.

When this project has "projected" it's first demo-version to it's
destinator, I will sit down and do some testing in order to get more
used to it. Then I will parse through the system and make it's
relevant changes.

Just...don't bite me...please :)

Best regards,
pfewww.

--- In IBObjects@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:
> Hi again, Svein Petter.
>
> Just thought that since you found your error, you may not have
taken proper
> notice of Randal's advice. Your SQL is doing the one thing Jason has
> consistently warned us against - using JOIN criteria in the WHERE
clause.
> If you use this ancient SQL standard, you MUST fill in JoinLinks -
but it's
> pretty simple to use more modern SQL (which eliminates the need for
> JoinLinks), i.e.
>
> Select *
> from TRANS
> JOIN DETAIL ON TRANS.TRANS_NR = Detail.TRANS_NR
> AND TRANS.REC_ID = DETAIL.TRANS_REC_ID
> where TRANS.PAY_MODE = 5
> AND DETAIL.REC_ID > 0
> AND TRANS.OP_MODE = 1
>
> If your program works with the old notation without JoinLinks,
you're just
> unlucky enough to postphone your problem - it might well bite you
when your
> selects get more complicated.
>
> JTAFT (Just to avoid future trouble),
> Set