-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of George Gallen
Sent: Monday, February 02, 2004 4:56 PM
To: 'U2 Users Discussion List'
Subject: RE: SELECT NOT WORKING [uv 10 - unix]At least this makes sense.
But is there a work around, rather than two selects and a merge.list?
George
>-----Original Message-----
>From: Martin Phillips [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 02, 2004 4:51 PM
>To: U2 Users Discussion List
>Subject: Re: SELECT NOT WORKING [uv 10 - unix]
>
>
>I suspect that since TYPE is a mutlivalued field, some records
>have CREDIT
>in one value and something else in another value. Given that
>every record
>meets the TYPE # "CREDIT" condition, I would take a careful
>look at the data
>to see if there is a stray value mark in every record resulting in an
>apparent extra value.
>
>The WITH clause says at least one element must meet the
>condition. The WITH
>EVERY clause may help depending on what you are trying to do.
>
>Martin Phillips
>Ladybridge Systems
>17b Coldstream Lane, Hardingstone, Northampton NN4 6DB
>+44-(0)1604-709200
>
>----- Original Message -----
>From: "George Gallen" <[EMAIL PROTECTED]>
>To: "'Ardent List'" <[EMAIL PROTECTED]>
>Sent: Monday, February 02, 2004 9:41 PM
>Subject: SELECT NOT WORKING [uv 10 - unix]
>
>
>> OK....What gives.
>>
>> GET-LIST MYLIST
>>
>> 253 ITEMS SELECTED
>> >SELECT FILE WITH TYPE # "CREDIT"
>> 253 ITEMS SELECTED
>> >
>>
>>
>>
>> BUT....
>>
>> GET-LIST MYLIST
>>
>> 253 ITEMS SELECTED
>> >SELECT FILE WITH TYPE = "CREDIT"
>> 10 ITEMS SELECTED
>
>_______________________________________________
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.oliver.com/mailman/listinfo/u2-users
>
_______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users