Subject: | Re: calcs and sorting
| Date: | Tue, 9 Mar 2021 21:52:52 +0000
| From: | Michael Kennedy <Info@KennedySoftware.ie>
| Newsgroups: | pnews.paradox-dos
|
On 09/03/2021 20:24, Bernie van't Hof wrote:
> The _d twice is ok. The diff of cols Dr and Cr values.
But "_d" is also used for the DATE field?
> You have docs!!
Yes - I have all the 4.02 and 4.5 docs, and WPP, and a number of other
PDoxDOS manuals, Dan's, etc, etc, etc... I might even have the 3.5 ones!
> I threw out my 4.5 manuals 15 years ago. I seem to
> recall they got wet. :(
Alcohol? Rage? ;-)
- M.
> 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.
|