Paradox Community

Items in pnews.paradox-dos

Subject:Multi-Line queries
Date:Tue, 8 May 2018 00:54:16 +1000
From:Bernie van't Hof <berniev@bje.com.au>
Newsgroups:pnews.paradox-dos
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