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
|