I agree! I also created a new database, as I described and the problem
disappeared...... not sure how it could depend on the data, but I'll be
looking at that next. Not sure what's going on, but I will find out!
Mike Sinclair
ForenSys wrote:
>
> IMHO this is not a bug, because the problem is not reproduceable. I set up
> two tables as you described and the BROWSE command works fine. You've
> probably got something else going on there - like a corrupted index. I
> believe that you can't even store trailing blanks in a TEXT column.
>
> Regards,
>
> Stephen Markson
> ForenSys The Forensic Systems Group
> www.ForensicSystemsGroup.com
> 416 482 2140
>
> ----- Original Message -----
>
> > >> >> > > 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)
