I like your fix better than mine, Bernie! David Blocker
----- Original Message ----- From: "Bernie Corrigan" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 4:58 AM Subject: [RBASE-L] - Re: Difference in way 1.864 works > 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> > >
