I am querying a file with multivalued fields but I am not getting a
precise enough selection. I want to find only those records where the
multivalues for two separate fields meet the criteria within the same
index.
The file is the order-log file. There is only one record for each order
number but
PROTECTED]
To: u2 users group u2-users@listserver.u2ug.org
Sent: Tuesday, October 11, 2005 9:02 AM
Subject: [U2] help with multivalue and when
I am querying a file with multivalued fields but I am not getting a
precise enough selection. I want to find only those records where the
multivalues
This is only a stab...
if you make field 7 the name of a phrase, say ACT.ACT, for the dict
item, with the phrase being in the same dict as
PH
ACTION ACT.DTE
then do the same query?
On 10/11/05, Jeff Powell [EMAIL PROTECTED] wrote:
I am querying a file with multivalued fields but I am not getting
U
Piers
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell
Sent: 11 October 2005 14:02
To: u2 users group
Subject: [U2] help with multivalue and when
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http
Jeff Powell wrote:
I am querying a file with multivalued fields but I am not getting a
precise enough selection. I want to find only those records where the
multivalues for two separate fields meet the criteria within the same
index.
The file is the order-log file. There is only one record for
Of Jeff Powell
Sent: Tuesday, October 11, 2005 6:02 AM
To: u2 users group
Subject: [U2] help with multivalue and when
I am querying a file with multivalued fields but I am not
getting a precise enough selection. I want to find only those
records where the multivalues for two separate
WITH selects records. WHEN only suppresses display of multivalued fields that
do not meet your selection criteria.
UniVerse/SQL makes this clearer, since you must specify both the selection
clause and the suppression clause. You can do this with LIST as well.
LIST filename field_list WITH