Paradox Community

Items in pnews.paradox-dos

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 


Copyright © 2004 thedbcommunity.com