Try sselect FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ "01"
LIST FILE CHARGE.CODE This display the record every time the CHARGE.CODE equals "01". -----Original Message----- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 30, 2008 9:03 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] by.exp when Try selecting without the BY.EXP. Jerry Banker > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 30, 2008 8:48 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] by.exp when > > Yes, sorry make that > 001 D > 002 1 > 003, 004 blank > 005 10R > 006 M > > And it still doesn't work. > > ----- Original Message ----- > From: "DAWES, Ray" > Date: Wednesday, January 30, 2008 9:07 am > Subject: RE: [U2] by.exp when > To: u2-users@listserver.u2ug.org > > > Surely field 2 of the dictionary should have the location in the > > file - > > a number. > > > > > > Ray Dawes > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Roger > > GlenfieldSent: 30 January 2008 12:29 > > To: u2 > > Subject: [U2] by.exp when > > > > Universe version 9.5 > > Prime Flavor > > Dictionary > > CHARGE.CODE > > 001 D > > 002, 003, 004 blank > > 005 10R > > 006 M > > > > SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ "01" finds zero > > recordsand there are lots of records where one of the multi- > > values = 01 > > > > I've also tried the old Pick flavor > > SORT FILE BY.EXP CHARGE.CODE EQ "01" without any luck. > > > > Any other thoughts or does Prime flavor Retrieve just not deal with > > by.exp like the Pick & Ideal versions? > > > > Thanks all. > > Roger > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > CONFIDENTIALITY NOTICE The information contained in this > > e-mail is intended only for the confidential use of the above > > named recipient. If you are not the intended recipient or person > > responsible for delivering it to the intended recipient, you have > > received this communication in error and must not distribute or > > copy it. Please accept the sender's apologies, notify the sender > > immediately by return e-mail and delete this communication. > > Thank you. > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/