Subject: | Re: calcs and sorting
| Date: | Tue, 9 Mar 2021 11:19:14 +0000
| From: | Michael Kennedy <Info@KennedySoftware.ie>
| Newsgroups: | pnews.paradox-dos
|
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.
|