You can try adding an VF that says: COUNT(NAME,"'")
To see if that works then do: SELECT VENDOR WITH XTEST GT 0 ------------------------------------ Bloomfield College David Wademan Senior DB Programmer / System Analyst [EMAIL PROTECTED] 467 Franklin Street ITS- Knox Hall 3rd Fl. Bloomfield, NJ 07003 tel: 973-748-9000 ------------------------------------ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 12:37 PM To: [email protected] Subject: RE: [U2] select statement with single quotes Tried it, same result. "Jerry Banker" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/12/2007 11:30 AM Please respond to [email protected] To <[email protected]> cc Subject RE: [U2] select statement with single quotes Have you tried using the LIKE option? SELECT CUSTOMER WITH NAME LIKE "...'..." -----Original Message----- From: Charlie Rubeor [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 10:21 AM To: [email protected] Subject: [U2] select statement with single quotes Unidata 6.1, this statement fails. :SELECT CUSTOMER WITH NAME = "[']" missing quote:...'''... . . . There are no indices on the file and it is not only related to the CUSTOMER file. Any filename and field will result in the same error message. For example, SELECT VENDOR WITH ADDRESS = "[']" results in the same message. Is this a known issue? More importantly, is there an option or setting that I can change to fix it? -------------------------------------------------- Charlie Rubeor Senior Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860-233-6251 x3498 Fax: 860-523-3690 Email: [EMAIL PROTECTED] -------------------------------------------------- ------- 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/ ------- 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/
