I have seen this behavior in R:Base lately. It seems to me that it is a new
wrinkle, but I may be wrong. It kinda makes sense, but I remember it was
cofusing to me too. Comparison of two data columns should not break just
because the underlying TEXT types have different defined lengths. But try
this:
UPDATE diaginfo SET diagname = (STRIM(diagname))
It may be that your data is padded with spaces.
If, after STRIMING the data, the problem persists, I would report it to the
RDCC.
Include a sample database and code.
-- Dennis McGrath
mailto:[EMAIL PROTECTED]
-- Tools for R:BASE programmers
http://www.enteract.com/~mcgrath/dennis
-- Full time consultant with SQL Resources
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of MJS
Sent: Monday, June 04, 2001 7:21 AM
To: Rbase List
Subject: Am I doing this right?
I have 2 tables, 1 column each (not really, but it simplifies my
question). Table 1 is called diaginfo and it's column is called
diagname (TEXT 50).
Table 2 is called pasthist and it's column is called disease (TEXT 36).
Most of the data does not fill the whole column. In Rbase for Windows,
the following does not yield any rows.....
BROWSE ALL FROM diaginfo WHERE diagname IN (SELECT disease FROM
pasthist)
But this works...
BROWSE ALL FROM diaginfo WHERE (SGET(DIAGNAME,36,1)) in (SELECT DISEASE
FROM pasthist)
Does this make sense?
TIA!
Mike Sinclair
