ok ( Been there, done that)
no - I'll try it.
D
Dennis McGrath wrote:
Ignore the nonsense on the first line!
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath
Sent: Tuesday, January 19, 2010 12:12 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Compare to CHAR(127) and higher
Set var vc1 text = (
Have you tried
WHERE (ICHAR(SGET(SPCME,1,1))) Between 127 and 255
Dennis McGrath
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Doug Hamilton
Sent: Tuesday, January 19, 2010 11:29 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Compare to CHAR(127) and higher
Here's a curious:
The following code worked last November:
UPDATE SeqTbl SET SPCME = NULL WHERE SPCME > (CHAR(127))
This was used to clean up some data in a conversion to 7.6, some rows
had one or more extended ASCII characters starting in the first position
of text columns.
I tried it last night (1/18/10) and got a "no rows were found" message,
although browsing the table displayed a number of rows with extended
ASCII characters in the column.
I tried the following:
BROWSE (SGET(SPCME,1,1)) FROM SeqTbl
It works, showing the correct standard or extended character.
BROWSE ALL FROM SeqTbl WHERE SPCME = (CHAR(255))
Works, showing rows with a single ASCII 255, a Latin small letter y with
diaeresis
BROWSE ALL FROM SeqTbl WHERE (SGET(SPCME,1,1)) = (CHAR(255))
Works, showing rows with single & multiple ASCII 255.
However,
BROWSE ALL FROM SeqTbl WHERE SPCME > (CHAR(127))
BROWSE ALL FROM SeqTbl WHERE (SGET(SPCME,1,1)) > (CHAR(127))
No rows exist
It seems ">" and "<" are no longer valid, only "=" works with the CHAR
function.
Was I just lucky in Nov or was there a subtle change in syntax?
Is there a db setting that would affect this?
Currently ver 7.6.8.30111
Tnx,
Doug
