Paradox Community

Items in pnews.paradox-dos

Subject:Re: Multi-Line queries
Date:Wed, 9 May 2018 03:49:48 +1000
From:Bernie van't Hof <berniev@bje.com.au>
Newsgroups:pnews.paradox-dos
" 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
with pdox!

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?

- Bernie

On 8/5/18 9:09 pm, Michael Kennedy wrote:
> 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