|Subject:||Re: CHECK and CHECKPLUS
|Date:||Sat, 7 Apr 2018 08:27:33 +1000
|From:||Bernie van't Hof <email@example.com>
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