RE: SELECT NOT WORKING [uv 10 - unix]
Title: RE: SELECT NOT WORKING [uv 10 - unix] I was about to ask if TYPE was indexed? That's also an obvious one ... if the index has somehow gotten out of sync. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 02 February 2004 22:08To: 'U2 Users Discussion List'Subject: RE: SELECT NOT WORKING [uv 10 - unix] YES. That worked. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 02, 2004 5:06 PM To: U2 Users Discussion List Subject: RE: SELECT NOT WORKING [uv 10 - unix] Try SELECT FILE WITH EVERY TYPE # "CREDIT" Harman Armstrong [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SELECT NOT WORKING [uv 10 - unix]
OKWhat 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
RE: SELECT NOT WORKING [uv 10 - unix]
Try WHEN insted of WITH -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 2:41 PM To: 'Ardent List' Subject: SELECT NOT WORKING [uv 10 - unix] OKWhat 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
RE: SELECT NOT WORKING [uv 10 - unix]
Is it possible that of the 253 records in MYLIST : 10 have a value of "CREDIT" somewhere in the m/v list in field "TYPE" all 253 have a value other than "CREDIT" somewhere in the same m/v list -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]OnBehalf Of George GallenSent: 02 February 2004 21:41To: 'Ardent List'Subject: SELECT NOT WORKING [uv 10 - unix]OKWhat gives.GET-LIST MYLIST253 ITEMS SELECTEDSELECT FILE WITH TYPE # "CREDIT"253 ITEMS SELECTEDBUTGET-LIST MYLIST253 ITEMS SELECTEDSELECT FILE WITH TYPE = "CREDIT"10 ITEMS SELECTEDWhy Do I have to search the = , save the list, then merge.list DIFF to dothe 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 TYPEWhat gives..GeorgeGeorge GallenSenior Programmer/AnalystAccounting/Data Division[EMAIL PROTECTED]ph:856.848.1000 Ext 220SLACK Incorporated - An innovative information, education and managementcompanyhttp://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
RE: SELECT NOT WORKING [uv 10 - unix]
actually I typed it wrong :(
SELECT
FILE WITHOUT TYPE # "CREDIT" gives the same
as
SELECT FILE WITH TYPE = "CREDIT"
and
SELECT
FILE WITHOUT TYPE = "CREDIT" gives the same
as
SELECT FILE WITH TYPE # "CREDIT"
Sorry..
George
-Original Message-From: George Gallen
[mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 4:55
PMTo: 'U2 Users Discussion List'Subject: RE: SELECT NOT
WORKING [uv 10 - unix]
Gives the same result as SELECT FILE WITH TYPE =
"CREDIT"
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Monday, February 02, 2004 4:57
PMTo: U2 Users Discussion ListSubject: Re: SELECT NOT
WORKING [uv 10 - unix]Just curious, does SELECT FILE WITHOUT TYPE = "CREDIT" Work?Bruce M NeylonHealth Care Management Group
___
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: SELECT NOT WORKING [uv 10 - unix]
Title: RE: SELECT NOT WORKING [uv 10 - unix] YES. That worked. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 02, 2004 5:06 PM To: U2 Users Discussion List Subject: RE: SELECT NOT WORKING [uv 10 - unix] Try SELECT FILE WITH EVERY TYPE # CREDIT Harman Armstrong [EMAIL PROTECTED] ___ 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
