Yes, agree totally.

In a slender defence of the 'wannabe's, how can they follow the rules -- if there are no rules!

But of course there are plenty of situations where they are essential as the result is built
from one snapshot of all 
the tables involved, at once. Sometimes multiple queries could be much more complicated.

Oh well, will just have to come up with something that's balanced and sensible. Whatever that
may be!!

- Bernie

On 8/5/18 9:08 pm, Steven Green wrote:
> first rule of paradox queries, 1987.. just because it CAN be done in one query, doesn't
mean it SHOULD be done in one query
> 
> unfortunately, most "wannabe" programmers never read the rules.. I still see weird stuff
that I've never seen before, or 
> even dreamt of, and most of it either doesn't work, or doesn't give the intended results..
but the the "wannabe" never 
> figured that out, and left it in the code
> 
> to me, your primary issue is that there are no rules for this, that you can apply.. no
baseline, like that date comparison
> 
> 
> -- 
> 
> Steven Green
> Myrtle Beach, South Carolina, USA
> 
> http://www.OasisTradingPost.com
> 
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Bernie van't Hof"  wrote in message news:5af06899@pnews.thedbcommunity.com...
> 
> I didn't properly consider multi-line queries before so much head-scratching.
> 
> Consider the following (not real!):
> query
> 
> accnums | A/C# | Account Name |
>          | _s   | check        |
> 
> transact | A/C# | Amt | Src | Dest   |
>           | _a   | >0  | _s  | not _s |
>           | _a   | <0  | _s  | _s     |
> 
> Clients | Client# | Co name |
>          | _a      | check   |
> 
> endquery
> 
> and
> 
> query
> 
> transact | A/C#           | Name                           
| Amt |
>           | checkplus as a | CHECKPLUS "Fred, Martha or Tim" | >0  |
>           | checkplus as a | checkplus fred                  |
<0  |
> 
> endquery
> Do_It!
> clearall
> 
> These are harmless enough and their intent pretty straightforward.
> 
> But how far do I take this? What level of complexity is acceptable/common etc?
> What's the minimum rule set? We know pdox allows some pretty wild stuff, but chokes on
others.
> 
> Regards,
> Bernie