Subject: | Re: Multi-Line queries
| Date: | Fri, 11 May 2018 13:21:27 -0400
| From: | "Steven Green" <greens@diamondsg.com>
| Newsgroups: | pnews.paradox-dos
|
Bernie.. paradox itself will create the SQL for any query.. maybe you can
find a way to extract the weird queries to text files and run them thru
paradox itself, as part of the conversion package
--
Steven Green
Myrtle Beach, South Carolina, USA
http://www.OasisTradingPost.com
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof" wrote in message
news:5af5d01d@pnews.thedbcommunity.com...
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
|