[DXBase] "via" in QSO labels

[Kc9um@aol.com]

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.---