Try escaping the quote, i.e.: :SELECT CUSTOMER WITH NAME = "[\']"
Or: :SELECT CUSTOMER WITH NAME LIKE "...\'..." Larry Hiscock Western Computer Services -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Rubeor Sent: Friday, October 12, 2007 8: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/
