Paradox Community

Items in pnews.paradox-dos

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.


Copyright © 2004 thedbcommunity.com