Thanks alot, was looking for this a while to !! ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[email protected]> Sent: Tuesday, December 03, 2002 9:51 PM Subject: Re: [DXBase] "via" in QSO labels
> Upon further reflection... > > I think I've figured out the problem, and a fix. > > The problem stems from the data stored, or not stored, in the MGR field. As > noted before, if there is a MGR, then If(CALL <> MGR) works. However, if > there is no MGR, in other words is a null or empty field, then If(CALL <> > MGR) still evaluates true since CALL has some value and MGR is a null and the > two are therefore not equal. The resulting true evaluation causes the first > argument to work and print the word "via" plus the MGR field which is empty. > This results in a label with only the word "via" printing out where there is > no MGR routing. > > The fix is a slight change in the logic so that the MGR field is examined > first to see if it is empty or contains a value. If MGR is empty, print a > null. If MGR has some value compare the CALL & MGR fields as before and if > they are not equal print the "via "+ MGR string. If the fields are equal, > print a null. The resulting line of new logic is: > > If(MGR = "","",If(MGR <> CALL,"via "+MGR,"")) > > Go to Tools/Design Labels and select the label to modify. Double click on > the text box showing the formula, double click on the line of code and in the > resulting window edit the logic formula. Be sure to pay attention to the > commas and the extra parens at the end. Click ok to accept the change, click > ok again and exit the design label module. The labels should print correctly > now. > > Probably not the most elegant bit of code, but changing the formula as above > results in the labels printing correctly with the "via" suppressed when there > is no MGR. > > Gary KC9UM > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > The reason this message is shown is because the post was in HTML > or had an attachment. Attachments are not allowed. > Please post in Plain-Text only.--- > _______________________________________________ > DXBase Reflector - Please visit us on the web at www.dxbase.com > - - - - - - - - - - - - - - - - - - - - - - - > To UNSUBSCRIBE please visit: > http://mailman.qth.net/mailman/listinfo/dxbase > >
