My guess is that a lot of parsing code is written around that sting for control and to change it, the whole world would come to a screeching halt. :-) (that is a smile) Backward compatibility.
Tom -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, October 12, 2007 10:40 AM To: [email protected] Subject: RE: [U2] select statement with single quotes This bug also exists in UniData! Also, when you get the... Enter <New line> to continue... ...question at the end of a page of "missing quote:...'..." errors, you can't enter 'Q' to quit! You have to [Ctrl]+C to quit. I tried in both Pick and UniData modes with no success. This select statement works fine in D3. I couldn't check jBase or QM though. On a side note, it never ceases to amaze me that this anachronistic "end of page" comment is still around. Hasn't it been thirty years since a [New Line] key existed on any keyboard? :-) Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker >Sent: Friday, October 12, 2007 8:30 AM >To: [email protected] >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/ __________ NOD32 2589 (20071012) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
