Paradox Community

Items in pnews.paradox-dos

Subject:self join
Date:Sat, 13 Feb 2021 17:09:00 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-dos
I don't (yet) handle multi-row queries so this was rejected:

    Query

      Vend_Reb | Rebate | Curr      | FxRate           |
               | _r     | "USD"     | CHANGETO ~FxRate |
               | _r     | NOT "USD" | CHANGETO 1       |

     Endquery

Easy. Just (for now) split the query.

But whats that _r link intending?
I tried with and without and the results seem to be the same.

- Bernie


Copyright © 2004 thedbcommunity.com