Subject | Re: [IBO] Error in statement? |
---|---|
Author | sveinpetter@hotmail.com |
Post date | 2001-08-01T11:41:16Z |
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:
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.taken proper
>
> Just thought that since you found your error, you may not have
> notice of Randal's advice. Your SQL is doing the one thing Jason hasclause.
> consistently warned us against - using JOIN criteria in the WHERE
> 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 foryou're just
> 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,
> unlucky enough to postphone your problem - it might well bite youwhen your
> selects get more complicated.
>
> JTAFT (Just to avoid future trouble),
> Set