Sorry to post this after David posted a summary, but I've managed
to make label expressions that do that he wants; namely: "label if a
condition is
met, no label if not met".
This technique relies on the fact that if you use the Int() function on a
logical
expression, it returns 1 for TRUE and 0
info Mailing List" [EMAIL PROTECTED]
Sent: Monday, September 11, 2000 2:08 PM
Subject: Re: MI Label expression ?
Sorry to post this after David posted a summary, but I've managed
to make label expressions that do that he wants; namely: "label if a
condition is
met, no label i
Dave,
Two issues with that.
1. I am assuming that you put that expression into the auto-label area
as an expression. That won't quite work because MapInfo will return the
result of that query (Which would be "T" for true) as a label. What you
want is to only show labels for
David,
The appropriate "operator" for SELECTs (or any "SQL" operation") where
wildcards are involved is:
LIKE
i.e.
name not like "UNNAMED%"
HTH
Dave
At 04:38 PM 09/10/2000, you wrote:
Greetings List
I've been tring to create an expression that would label a streams layer
with only valid
This is actually because MapInfo turns numbers to integers to characters
when it concatenates. This gets rid of the commas. You can use functions
to make it work though. I actually answered a version of this for one of
my training clients before. We wrote up a quick FAQ for them. While it
Dear Jason
One way to do what you want is :-
Run a select on your base table and select records where 0. Give the
output a name eg NONZERO
Now go to layer control and add in the layer NONZERO and label it. As
this table only contains non zero values you will only be labelling non
zero values.