:47 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
Bill,
Try OR instead of AND.
Eric
-Original Message-
From: Bill Haskett [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2008 11:19 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
Jeff
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Tuesday, June 24, 2008 12:12 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
Eric:
That doesn't work either.
list APOPEN WITH ANY ACCTS UNLIKE 52... OR WITH ANY ACCTS UNLIKE 29...
INVDATE
COMMENT ACCTS AMTS
@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
I take it that you checked to make sure that the fields were associated so
let's take a different look. Are the values separated by value marks or
sub-value marks? What does the dictionary contain? What does the record
below look like in the editor
))) # THEN 0 ELSE 1
Then you would be a select based on this dictionary be equal to a 1.
-Original Message-
From: Eric Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 1:17 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
Bill,
Sorry
: [U2] Friday query logic
If this is not working, create a dictionary item that does the
evaluation you want and have it return a 1 if it meet the condition and a 0 if
it does not.
Dictionary would look like
IF FIELD[1,2] # SF OR FIELD[1,2] # SH THEN 0 ELSE IF
CONVERT(SH
@listserver.u2ug.org
Subject: RE: [U2] Friday query logic
I take it that you checked to make sure that the fields were associated so
let's take a different look. Are the values separated by value marks or
sub-value marks? What does the dictionary contain? What does the record
below look like in the editor
quote who='Eric Armstrong' date='Monday 23 June 2008'
Jeff,
In Universe there is a (apparently undocumented) keyword ANY which can be
used, i.e.
SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH...
which may be just what you want.
Eric:
You get the prize - I'm on Unidata
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Jeffrey Butera
Sent: Monday, June 23, 2008 10:20 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Friday query logic
quote who='Eric Armstrong' date='Monday 23 June 2008'
Jeff,
In Universe
Can you do a SELECT to select the ones WITH EVERY FIELD LIKE SF... SH...
and then do NSELECT to select the inverse set?
- Original Message -
From: Jeffrey Butera [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
Date: Fri, 20 Jun 2008 11:25:30 -0400
I experimented with it and got much closer with:
SELECT FILE WITH EVERY FIELD UNLIKE SF... AND WITH EVERY FIELD UNLIKE
SH...
It is not quite what you want but much closer.
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
Date: Fri, 20 Jun 2008 11:25
: Saturday, 21 June 2008 3:26 a.m.
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
I can't get my head around the proper query logic on this Friday.
I have a FILE with mv FIELD containing strings. I want to query records
where at least one of the FIELD values doesn't begin with SF
] On Behalf Of
Jeffrey Butera
Sent: 20 June 2008 16:26
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
I can't get my head around the proper query logic on this Friday.
I have a FILE with mv FIELD containing strings. I want to
query records where at least one of the FIELD
Perhaps a UniBasic program would be workable.
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeffrey Butera
Sent: Friday, June 20, 2008 11:26 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
I can't get my head around
Subject: [U2] Friday query logic
I can't get my head around the proper query logic on this Friday.
I have a FILE with mv FIELD containing strings. I want to query
records where
at least one of the FIELD values doesn't begin with SF... or
SH
To be clear: I don't want records if any
] Friday query logic
Date: Fri, 20 Jun 2008 11:25:30 -0400
I can't get my head around the proper query logic on this Friday.
I have a FILE with mv FIELD containing strings. I want to query records
where
at least one of the FIELD values doesn't begin with SF... or SH
To be clear: I don't
] On Behalf Of Jeffrey Butera
Sent: Friday, June 20, 2008 8:26 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Friday query logic
I can't get my head around the proper query logic on this Friday.
I have a FILE with mv FIELD containing strings. I want to query records
where
at least one of the FIELD
] Friday query logic
I can't get my head around the proper query logic on this Friday.
I have a FILE with mv FIELD containing strings. I want to query records
where
at least one of the FIELD values doesn't begin with SF... or SH
To be clear: I don't want records if any of the following occurs
17 matches
Mail list logo