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/

Reply via email to