Paradox Community

Items in pnews.paradox-dos

Subject:Re: self join
Date:Sun, 14 Feb 2021 20:54:53 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-dos
Me too!

The Rebate column is actually type $, so makes even less sense.

This query is over 25 years old and it is entirely possible that when it 
was written I was guessing a bit.

It does seem to work the same with or without the _r links, so they 
appear to do nothing. But that just doesn't feel right.


On 14/2/21 10:51 am, Michael Kennedy wrote:
> 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