Paradox Community

Items in pnews.paradox-dos

Subject:Re: self join
Date:Mon, 15 Feb 2021 10:31:41 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-dos
Seems it is harmless, likely ignoring the links, but I split it anyway.
Nice to know it is technically incorrect. I had no idea how to mimic its 
behaviour!

On 15/2/21 1:03 am, Steven Green wrote:
> 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