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