Mike,

When building multi query queries like these was it your presumption that paradox would treat
them each:
a) as operating on a snapshot of the data as at the start of the query, or
b) sequentially?

- Bernie

On 11/5/18 8:02 am, Michael Kennedy wrote:
> Bernie,
> 
> I collected some of the multi-line queries from one of my bigger apps, and dropped them
into a single .SC file, as 
> attached.
> 
> If you glance through the file, it might give you an idea of the multi-line stuff that
I used in live apps, back about 
> 20years ago...
> 
>    - 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