Paradox Community

Items in pnews.paradox-dos

Subject:Re: self join
Date:Sun, 14 Feb 2021 10:03:13 -0500
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-dos
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

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof"  wrote in message 
news:60277b0d$1@pnews.thedbcommunity.com...

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