Allen, Changing the first letter of the verb forces processing of the query in 'U'nidata mode so you have to use 'LIKE' instead of '='.
If that doesn't work, try a virtual dictionary item that calls a subroutine that outputs "IN" for every occurance of '"'. Tom -----Original Message----- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 12:48 PM To: [email protected] Subject: RE: [U2] TCL literal select Allen: I use UD in PICK mode and the query processor has the same problem as the OP noted. UD doesn't like single quotes in PICK mode. In fact, numerous things don't work in AQL when in PICK mode. I wasn't able to get any of the suggestions to work in UD. Bill >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Allen Egerton >Sent: Tuesday, August 12, 2008 6:56 PM >To: [email protected] >Subject: Re: [U2] TCL literal select > >Bruce Ordway wrote: >> Hi, >> >> I work with a Unidata/Dataflo system on HPUX. >> I am having trouble selecting records in my PARTS file. >> >> I want to select all parts that have a " in the description field (F1). >> People have been using " instead of INCH. >> This causes problems for me during processing some reports and exports. >> > >To include double-quote within field to be searched, use single quote >as delimiter. > >SELECT PARTS WITH F1 = '["' >-or- >SELECT PARTS WITH F1 LIKE '..."...' > > >-- >Allen Egerton >aegerton at pobox dot com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
