That was the key; it showed that the only problem with Larry's
suggestion was that the zero had to be in the CHAR(0174).
Thanks to both of you for your help.
Joan
Paul InterlockInfo wrote:
Try using (char(char_value)) and see if that works. I have had better luck
at times. I recall (char(039))
Sincerely,
Paul Dewey
New Horizon Interlock Inc.
New Horizon Safety Diagnostics Inc.
www.interlockinfo.com
Saving Lives - One Breath at A Time T
IMPORTANT NOTICE: This electronic communication and any attachments may
contain confidential information and may be legally privileged. It is
intended solely for the addressee(s). Access, disclosure, copying,
distribution, or reliance on any of it by anyone else is prohibited and may
be a criminal offense. Please delete if obtained or received in error, and
email confirmation to the sender.
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Joan
Peterson
Sent: Monday, September 14, 2009 5:43 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Special Characters
I have had several people with apostrophes in their names for years,
back to the 80's, so I've been using the double quotes for a long time now.
I tried both ways and still got the same message.
Joan
Paul wrote:
UPDATE members set fullname = (SRPL(fullname, '(R)', (char(174)),0))
where lname exists and fullname contains '(R)'
" verses ' unless you changed your settings?
Paul D
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Joan
Peterson
Sent: Monday, September 14, 2009 2:53 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Special Characters
The individual replacement method using character 174 worked fine, but
there were several places where the change needed to be made (It
appeared in multiple columns), so I tried the command line UPDATE
TableName SET ColumnName = (SRPL(ColumnName, '(R)', (CHAR(174)), 0))
WHERE IDColumn = .vIDValue AND ColumnName CONTAINS '(R)', using " for my
quotes. Here is my code, and the error it produced:
UPDATE members set fullname = (SRPL(fullname, "(R)", (char(174)),0))
where lname exists and fullname contains "(R)"
-ERROR- Unrecognized command - retype it ( 40)
To test it, I used the SELECT command first, and it showed me the lines
to be changed; however, when I used the UPDATE command, I got the error
message. Any other thoughts?
Joan
Lawrence Lustig wrote:
<<
Is there a way in an Extreme9 table to use special characters? I have
several listings which include credentials initials, many of whom are
registered. I have been using (R) for this symbol and have to convert
it in any of the other programs I export to, in order for the
Registered symbol to appear. Example: Smith, John F., CFP(R)
In the standard font encoding, the registered trademark symbol is
character 174. Users can enter it directly by holding down ALT and
typing 0174 on the numeric keypad. Alternatively, you can allow the
users to continue entering (R) and then, after the record is saved,
doing an
UPDATE TableName SET ColumnName = (SRPL(ColumnName, '(R)',
(CHAR(174)), 0)) WHERE IDColumn = .vIDValue AND ColumnName CONTAINS '(R)'
Or you can offer both.
--
Larry
