Paradox Community

Items in pnews.paradox-dos

Subject:Re: too clever?
Date:Tue, 9 Mar 2021 21:48:31 +0000
From:Michael Kennedy <>
On 09/03/2021 21:38, Bernie van't Hof wrote:
> atable | A/C#  | Amt      | otherCols |
>         | CHECK | CALC SUM |           |
> Result:
> One row per A/C# being total of Amt for that A/C#
> Beautiful.

Yep - very common query... no issues...

> Change CHECK to CHECKPLUS. Likely select additonal columns
> Result:
> For EVERY table row, A/C# and Sum for that A/C#.

Yep, but kinda pointless:
   - Either leave the 'Calc Sum' (with no CHECK/CHECKPLUS in the Amt field),
   - Or drop a CHECK or CHECKPLUS into the Amt field, and drop the Calc.

> Handy sometimes, back in the day. Really?

Makes no sense to me - see above. But, maybe a leftover from someone 
adjusting old code (badly)?

> But a bit too clever. Repeating summary data amongst source data is BAD.
> And converting it is difficult, so I won't! I'm going to error it.

All agreed.

   - Michael

Copyright © 2004