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/

Reply via email to