Paradox Community

Items in pnews.paradox-dos

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


Copyright © 2004 thedbcommunity.com