Karen scooped me on this one and I missed it in her first email. It was originally her idea.
At 10:21 AM 6/13/2003 -0400, you wrote: >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> >> >> > >
