OK......so......let's create a new database, 2 tables, 1 column each 1
row of data each, and check again!
Mike Sinclair
Chuck Lockwood wrote:
>
> 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
