Subject: | Re: Multi-Line queries
| Date: | Sat, 12 May 2018 03:17:16 +1000
| From: | Bernie van't Hof <berniev@bje.com.au>
| Newsgroups: | pnews.paradox-dos
|
Most of these are selects with various tests, which are not too hard to convert using multiple
queries and UNION.
There are some that change or delete and that is giving me pause for thought. Maybe the only
way is multiple queries in
a TRANSACTION, but that causes complications building the CHANGED and DELETED result tables.
Mmmmmmm.
Also a timely reminder to implement "!". I currently recognise it but don't follow through in
the join.
And I bet you had fun with this one:
On 11/5/18 8:02 am, Michael Kennedy wrote:
> Menu {Ask} Select Trans_01_Tmp
> Moveto [Account No] "_ac"
> Moveto [Year End Date] "_dt"
> Moveto [Run Batches] "Y"
> Moveto [Business Typ] "~ForB" ;Fishing/BUSINESS
>
> MENU {Ask} SELECT TaxPadP
> MOVETO [Account No] "_a!,_ac" CHECKPLUS
> MOVETO [Year End Date] "_b!,_dt" CHECKPLUS
> [Line No] = "~tot_line" ;= match on line "37"
> DOWN ;A-N-D (because of next _a,_b)
> MOVETO [Account No] "_a" ;??? Maybe ",count=0" here also
> MOVETO [Year End Date] "_b" ;??? Maybe ",count=0" here also
>
> [Line No] = "not ~tot_line,count=0" ;have a total of NO
> ;lines, WITHOUT 37
> Do_It! Qry_is_Ok("B18") ClearAll
>
- Bernie
|