My 2 cents ....
If diagname is an indexed column that is corrupted, case #1
would fail but case #2 would succeed.
So not necessarily a bug.
Chuck Lockwood
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LockData Technologies, Inc.
309 Main Avenue, Hawley, Pa 18428
Phone: 570-226-7340 ~ Fax: 570-226-7341
Email: [EMAIL PROTECTED] ~ http://www.lockdata.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of MJS
Sent: Monday, June 04, 2001 8: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
