RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-03 Thread Anthony Youngman
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Jeff Schasny
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread Piers Angliss
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

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
ssage-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 PRO

RE: SELECT NOT WORKING [uv 10 - unix]

2004-02-02 Thread George Gallen
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