Good thought, but no change. Before I report it, does anybody else
think this is a bug? or should the length of the text column be a
factor
Dennis McGrath wrote:
>
> 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
