Paradox Community

Items in pnews.paradox-dos

Subject:Re: Multi-Line queries
Date:Tue, 8 May 2018 13:33:50 -0400
From:"Steven Green" <greens@diamondsg.com>
Newsgroups:pnews.paradox-dos
yeah, Mike.. but YOU doing multi-line queries isn't the same as a "wannabee" 
doing multi-line queries

--

Steven Green
Myrtle Beach, South Carolina, USA

http://www.OasisTradingPost.com

Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Michael Kennedy"  wrote in message 
news:5af18555$1@pnews.thedbcommunity.com...

Bernie,

In my PDoxDOS apps, I used multi-line queries "a lot" - maybe half
(maybe much more!) the queries are multi-line? I think I sent you some
examples one/two months back...

I think I often had about the same number of lines for each table,
perhaps to avoid some PDoxDOS error-messages (eg, something like "Query
asks unrelated questions"), but I don't recall the exact reasons. Eg, in
you example, I might have inserted two lines for the ACCNUMS table:

> accnums | A/C# | Account Name |
>         | _s1  | check        |
>         | _s2  | check        |
>

and used s1 or s2 elsewhere...

   - Mike


On 07/05/2018 15:54, Bernie van't Hof wrote:
> 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