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
|