Subject: | Re: self join
| Date: | Sun, 14 Feb 2021 00:51:42 +0000
| From: | Michael Kennedy <Info@KennedySoftware.ie>
| Newsgroups: | pnews.paradox-dos
|
I haven't tried that, Bernie, but maybe PDoxDOS will reject the query
with something like "Query has unrelated Rows...", if the "_r" is omitted?
On the other hand, is the query seeking rows where it'll change the
FxRate, only if it finds some rows with USD, A-N-D some without USD, for
the SAME Rebate code? If so, then, if all the entries for a Rebate code
have USD, or if all the entries do not have USD, it will not change the
FxRate?
Or am I totally confusssssed?!!
Wow!
--------------
Running separate queries sounds OK to me, though it might be a little
slower on large tables.
- M
On 13/02/2021 07:09, Bernie van't Hof wrote:
> 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
|