Paradox Community

Items in pnews.paradox-dos

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 


Copyright © 2004 thedbcommunity.com