: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
@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
@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
Jeffrey,
I've found that WHEN, instead of WITH, is better at limiting the values
returned to a select.
i.e. SELECT FILE WHEN FIELD UNLIKE SF... OR WHEN FIELD UNLIKE SH...
Andrew
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey Butera
Sent:
Jeff
SELECT DISTINCT @ID TO SLIST 0 FROM UNNEST FILENAME ON FIELD WHERE
NOT(FIELD LIKE
'SF%' OR FIELD LIKE 'SH%') ;
The SQL is less of an overhead than doing a by-exp with SAVING UNIQUE @ID in
RetrieVe.
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
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 the
I'm sure there's a much cleverer query-only way of doing this. But I'd
just do a merge list. Select all the records into one list. Select
into another all records WITH EVERY FIELD LIKE 'SF...''SH...' Then grab
the difference.
Katie
Katie Morgan
Datatel Programmer/Analyst
Linfield College
I think you are on the right track with this one, but change the AND to OR. I
wanted to include the EVERY keyword before each field but I think that is
assumed.
SELECT FILE WITH FIELD UNLIKE SF... AND FIELD UNLIKE SH...
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: [U2]
Use WHEN instead of WITH on MV fields?
Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Cell 650-207-3235
Fax 650-556-9204
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Why not write a new dictionary item?
This can set a flag if FIELD is neither SF456 nor SH456.
Let's call it VALID.FIELD
I would use the following A-correlative
A;IF N(FIELD) = SF456 THEN ELSE IF N(FIELD) = SH456 THEN ELSE 1
That would work at least in UniData - not sure if UV supports
17 matches
Mail list logo