There are 2 problems I have seen in the past (with all versions). 1st, (the simple one)... check the dictionary item to make sure it is set as multivalue (for D/I types, this is an "M" in field 6)
------------------- 2nd... Rec-a credit}nocredit Rec-b credit Rec-c nocredit Select file with field = "credit" 2 records selected. (rec-a, rec-b) Select file with field = "nocredit" 2 records selected. (rec-b, rec-a) This is due to the way Universe interprets "=" when it comes to multivalues. If no multivalue select phrase is used, "ANY" is assumed. If you wish to control that, use EVERY or ANY depending on what you want. Select file with every field = "credit" 1 record selected. (rec-a) Select file with every field ne "credit" 1 record selected. (rec-c) Select file with any field = "credit" 2 records selected. (rec-a, rec-b) Select file with any field ne "credit" 2 records selected. (rec-b, rec-c) Perhaps what you want is: >SELECT FILE WITH EVERY TYPE # "CREDIT". Also, look at the data. Try the following... >GET-LIST MYLIST 253 ITEMS SELECTED >SELECT FILE WITH TYPE # "CREDIT" 253 ITEMS SELECTED >SELECT FILE WITH TYPE = "CREDIT" 10 ITEMS SELECTED >LIST FILE TYPE This should show you what values are causing you problems. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Monday, February 02, 2004 3:41 PM To: 'Ardent List' 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 > Why Do I have to search the = , save the list, then merge.list DIFF to do the same thing as select # ? The ONLY thing is that TYPE is multivalued field. It is defined in the DICT as multivalued. There is NO entry in VOC called TYPE What gives.. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - An innovative information, education and management company http://www.slackinc.com _______________________________________________ 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
