|Date:||Tue, 8 May 2018 00:54:16 +1000
|From:||Bernie van't Hof <firstname.lastname@example.org>
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 on others.