Paradox Community

Items in pnews.paradox-dos

Subject:Re: Multi-Line queries
Date:Sat, 12 May 2018 22:08:56 +0100
From:Michael Kennedy <Info@KennedySoftware.ie>
Newsgroups:pnews.paradox-dos
Always operating on a snapshot.

   - Mike


On 12/05/2018 17:04, Bernie van't Hof wrote:
> 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


Copyright © 2004 thedbcommunity.com