Paradox Community

Items in pnews.paradox-dos

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.


Copyright © 2004 thedbcommunity.com