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.
|