G'day Steve,
Here is a solution for a simple comparison, eg if column = "Some Value" then
draw a label.
Left$(ColumnX,(InStr(1,ColumnY,"Criteria")*255))
ColumnX is the column containing the labels.
ColumnY is the column containing the criteria for labeling
The InStr$() function will return 0 if the string is not matched, so the
record will be labeled with a 0 * 255 length string.
I think you could conjure up a greater than solution using the Minimum()
function.
For a value greater than or equal to 99:
Left$(ColumnX,(InStr(1,Str$(Minimum(99,ColumnY)),"99")*255))
Neil Moseley
Geodata Computing Services
http://members.iinet.net.au/~mose/
----- Original Message -----
From: "Steve Carlsson" <[EMAIL PROTECTED]>
To: "MapInfo-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 10:34 AM
Subject: MI-L Label Expressions
> Hi Listers
>
>
>
> Is it possible to use an If Then statement in labelling.
>
> Obviously we can use an expression to label with more than one column.
The
> question is can we create an expression that will label:
>
> IF the value in one collum is > than x THEN use label from another column
> (same row)?
>
> EG I have a bar graph with a column of data which is the detection limit
for
> a mineral. If the detection limit is reached then graph the value in the
> actual value column, not the detection limit column...
>
> Does this make sense...?
>
> Any info would help.
>
> Regards
>
>
>
> Steve Carlsson
> Sales Manager
> Digital Mapping Solutions Pty Ltd
> Ph 089 474 6311 Fax 089 474 6411
> Mobile 0411 736 116
> 2/2 Hardy Street SOUTH PERTH WA 6151
> www.mapsys.com.au
>
>
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
