[DXBase] "via" in QSO labels

[Phil ON4VP]

Thanks alot, was looking for this a while to !!

----- Original Message -----
From: <Kc9um@aol.com>
To: <Kc9um@aol.com>; <dxbase@mailman.qth.net>
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
>
>