Paradox Community

Items in pnews.paradox-dos

Subject:Re: CHECK and CHECKPLUS
Date:Sat, 7 Apr 2018 08:27:33 +1000
From:Bernie van't Hof <berniev@bje.com.au>
Newsgroups:pnews.paradox-dos
Yes, I've gone back over much of my old code and I too find no instance of mixing them.
So for now it may be simplest to test for the condition but error it out. I do have a sort of
solution in mind should it 
ever come up.

On 7/4/18 4:02 am, Michael Kennedy wrote:
> I can't help, Bernie...
> 
> In all queries, AFAIR, I always use only CHECK (or some/all fields), or only CHECKPLUS
(on some/all) - I think I've 
> never mixed them.
> 
>    - Mike
> 
> 
> On 06/04/2018 08:27, Bernie van't Hof wrote:
>> 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


Copyright © 2004 thedbcommunity.com