|Subject:||Re: Multi-Line queries
|Date:||Wed, 9 May 2018 03:49:48 +1000
|From:||Bernie van't Hof <email@example.com>
" perhaps to avoid some PDoxDOS error-messages (eg, something like "Query asks unrelated questions")"
Push the limits until a problem, then pull back to something safe. It seems it was always thus
Well we had to. As Steve says: there were no rules.
Interesting that you used multi-row "a lot". I used them "sometimes".
Main take-out is they must be supported. Same old question though: How long is a piece of string?
On 8/5/18 9:09 pm, Michael Kennedy wrote:
> 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!):
>> 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 |
>> transact | A/C# | Name
| Amt |
>> | checkplus as a | CHECKPLUS "Fred, Martha or Tim" | >0 |
>> | checkplus as a | checkplus fred
| <0 |
>> 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