Karen -
Confirmed your results using some virtually identical code here with
+'s and &'s. The problem first appeared in 1.862 and continues in 1.864 and
1.866. 1.851 executes the code correctly with either +'s or &'s.
A workaround is to substitute (IFNULL(colname, '.', colname)) for
the column which has the NULL's in it. This sticks "." in as the first
character in the column position in the menu and everything else lines up as
it should. Tried using ' ' instead of '.' in the IFNULL expression and this
had the effect of disappearing all of the information on the right side of
the menu line after the NULL was encountered. You could probably use any
character you want here (other than " ") and this will get you the increased
functionality of 1.864 with slightly funky menus.
Bernie
At 06:07 PM 6/12/2003 EDT, you wrote:
>
>Nope, replacing & with + doesn't make a difference.
>
>
>
>
>Try using + instead of the &operator. The rule for & is that it
>concatenates blanks leaving just one. I'm surprised the code below ever
>worked at all. Try
>
> CHOOSE vAsk FROM #VALUES FOR ( +
> LJS(CompanyName,25) + LJS(city,12) + LJS(State,4) ) +
> FROM companies WHERE .....
>
>
>
>
>
>Isn't RBTI finished with releasing more patches of 6.5++?
>
>>I suggest that you post it to RDCC.
>
>
>Karen
>
><HTML><FONT FACE=arial,helvetica><FONT SIZE=2 FAMILY="FIXED" FACE="Courier
New" LANG="0"><BR>
>Nope, replacing & with + doesn't make a difference.<BR>
><BR>
> </FONT><FONT COLOR="#000000" style="BACKGROUND-COLOR: #ffffff" SIZE=2
FAMILY="SANSSERIF" FACE="Arial" LANG="0"><BR>
><BLOCKQUOTE TYPE=CITE style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT:
5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">Try using + instead of the
&operator. The rule for & is that it<BR>
>concatenates blanks leaving just one. I'm surprised the code below
ever<BR>
>worked at all. Try<BR>
><BR>
> CHOOSE vAsk FROM #VALUES FOR ( +<BR>
> LJS(CompanyName,25) + LJS(city,12) + LJS(State,4) ) +<BR>
> FROM companies WHERE .....<BR>
></BLOCKQUOTE><BR>
><BR>
><BR>
></FONT><FONT COLOR="#000000" style="BACKGROUND-COLOR: #ffffff" SIZE=2
FAMILY="FIXED" FACE="Courier New" LANG="0">Isn't RBTI finished with
releasing more patches of 6.5++?</FONT><FONT COLOR="#000000"
style="BACKGROUND-COLOR: #ffffff" SIZE=2 FAMILY="SANSSERIF" FACE="Arial"
LANG="0"><BR>
><BR>
>>I suggest that you post it to RDCC.<BR>
><BR>
><BR>
></FONT><FONT COLOR="#000000" style="BACKGROUND-COLOR: #ffffff" SIZE=2
FAMILY="FIXED" FACE="Courier New" LANG="0">Karen<BR>
></FONT></HTML>
