I dunno. Last time this was discussed it was 12? (!)

On 7/4/18 1:51 am, Steven Green wrote:
> pdoxwin qbe is exactly the same.. doesn't matter where you post questions, how many of
us do you think there really are? 
> :-)
> 
> 
> -- 
> 
> 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:5ac79079$1@pnews.thedbcommunity.com...
> 
> Thanks Steve,
> 
> I can see it can be done in sql using groups etc, but my problem, as usual, is remembering
how pdox worked.
> 
> Not is not an issue.
> 
> Is pdoxwin similar re qbe? Maybe I should ask this in another section?
> 
> - Bernie
> 
> On 7/4/18 12:43 am, Steven Green wrote:
>> I haven't played with that in many years, but my guess is that paradox allowing a checkplus
in selected fields, as 
>> apposed to all or nothing, is not reproducable in SQL.. probably done internally, the
same way the "not" query is 
>> done.. create a too-big answer set, then reduce it, then display it
>>
>> easier to explain with the "not" query.. it grabs everything the query requests, then
does the "not" step separately.. 
>> you can can see that by testing the size of the answer table.. it might be empty, but
it'll still be the size it was 
>> before it removed all the "not" records
>>
>> -- 
>>
>> 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:5ac72161$1@pnews.thedbcommunity.com...
>>
>> Pdox allows a query to contain both CHECK's and CHECKPLUS's which roughly translate
to SELECT DISTINCT and SELECT in sql.
>>
>> sql does not allow both in the same query due to possible uncertainties/ambiguities.
>>
>> I thought I had this nailed, but on closer inspection it seems my recollection of how
pdox works in this regard is not
>> so clear, although I do remember sometimes struggling to get the mix right.
>>
>> Anyone help?
>>
>> - Bernie 
>