Paradox Community

Items in pnews.paradox-dos

Subject:Re: self join
Date:Sun, 14 Feb 2021 10:03:13 -0500
From:"Steven Green" <>
that's actually two changeto, and should be two separate queries.. this 
changeto or that changeto.. as a scan, it's a simple if this else that.. if 
that query works, it shouldn't


Steven Green
Myrtle Beach, South Carolina, USA

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof"  wrote in message 

I don't (yet) handle multi-row queries so this was rejected:


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


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