Hi,
About the true/false thing, I always use 0 and 1 but I was chastised
about that by a colleague recently, that it might not be completely
cross-platform, and now I stutter on it every time I do that,
wondering if I'm not really following a best practice
I seem to recall this same topic
And then there's the query language:
Suppose INVOICED field is supposed to be true or false. Stored as 1 or
0, but maybe left null in some records (We've all been there.):
SELECT CUSTOMER WITH INVOICED
If INVOICED is 0 or null, will said CUSTOMER record be selected or not?
UV selects
Hi,
The query processor defines WITH fieldname that has no relational operator as
a test for non-null so this is not the same as a
true/false test. Again, as far as I know, this is the same across all
multivalue products.
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane,
UniData treats WITH fieldname as the equivalent of WITH fieldname .
Both 1 and 0 would be selected, the empty string would not.
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf
There is only one truth, and it's false (0 or ).
On Wed, Jul 31, 2013 at 8:30 AM, Larry Hiscock lar...@wcs-corp.com wrote:
UniData treats WITH fieldname as the equivalent of WITH fieldname .
Both 1 and 0 would be selected, the empty string would not.
Larry Hiscock
Western Computer
On 31/07/13 09:06, Martin Phillips wrote:
Of course, nothing is ever completely black and white. As multivalue Basic
has developed, internal data types have gone beyond
simply numbers and strings. If I write
IF FVAR THEN ...
where FVAR is a file variable, what do I expect this to do? The
On this sidethread, like a true hacker I poked rather a lot at the Ultimate
implementation of the Select variable
I discovered that the groupid was embedded in that variable, if you walk it
byte-by-byte
So I was able to use that to show the users, on a BASIC SELECT how *far* the
select had
Hi Wil,
That indeed was my code - ten years old now!
I think I read the same article as Kevin. I don't use it in my day to day
programming (which is in Universe and QM, thus using @TRUE and @FALSE) but I
think I still would use it for Pickwiki. Just a style thing - de gustibus non
disputandum
From: Keith Johnson
Hi Tony,
'Twas a teensy bug under an unusual circumstance... Hey, wait a
minute, you're the one who complained that no-one updated other
people's code! You wouldn't be trying to yank Will's chain, would
you?
Indeed I do comment occasionally on the proportion of takers to