Paradox Community

Items in pnews.paradox-dos

Subject:Re: calcs and sorting
Date:Wed, 10 Mar 2021 06:24:13 +1000
From:Bernie van't Hof <onrequest@somewhere>
Newsgroups:pnews.paradox-dos
I thought the same re CHECKPLUS and sorting. I was unsure what effect 
CHECK and CHECKPLUS would have with what I call a horizontal calc as 
these are unique to each row. Hence the tests.

The _d twice is ok. The diff of cols Dr and Cr values.

You have docs!! I threw out my 4.5 manuals 15 years ago. I seem to 
recall they got wet. :(

- Bernie

On 9/3/21 9:19 pm, Michael Kennedy wrote:
> Bernie,
> 
> I think the basic rule is: "If there's any 'CheckPlus', then ALL matches 
> are extracted/processed, and no sorting is done?". However, I'd need to 
> either check the docs, or run a few tests.
> 
> Also, the query has "_d" in two different fields, so would that either 
> cause syntax errors, or create an empty answer table?
> 
>    - Michael
> 
> 
> 
> On 08/03/2021 22:16, Bernie van't Hof wrote:
>> Given:
>>
>>
>> Table | A/C#  | Ref   | Date                        |
>>        | CHECK | CHECK | _d, CALC TODAY - _d as Days |
>>
>> Table | Dr                      | Cr    |
>>        | _d, CALC _d - _c as Bal | _c    |
>>
>>
>>    Q1. What, if any, sorting?
>>    Q2. Change CHECKs to CHECKPLUSs. Repeat Q1.
>>
>>
>> What I'm seeing:
>>
>>    A/C# and Ref: sorted.
>>    Bal:          not sorted.
>>    Days:         sorted if CHECKs, not if CHECKPLUSs. <== Why ?
>>
>> It would appear stupid to ever use CHECKPLUSs but it might be 
>> significant someplace else.


Copyright © 2004 thedbcommunity.com