Paradox Community

Items in pnews.paradox-dos

Subject:Re: Multi-Line queries
Date:Tue, 8 May 2018 12:09:14 +0100
From:Michael Kennedy <Info@KennedySoftware.ie>
Newsgroups:pnews.paradox-dos
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