Subject: | Re: Multi-Line queries
| Date: | Tue, 8 May 2018 07:08:29 -0400
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-dos
|
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
|