When you say you need to find the highest value in each record I take it that
you don't mean the highest value in each field/column ?
To find the highest of seven values you must compare them individually:
Select Maximum(FIELD1, Maximum(FIELD2, Maximum(FIELD3, Maximum(FIELD4,
Maximum(FIELD5, Ma
Like this:
maximum(maximum(maximum(field1,field2),field3),field4)
Kind regards
Uffe Kousgaard
www.routeware.dk
- Original Message -
From: "Ronning, Christine" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 28, 2005 10:35 PM
Subject: MI-L Maximum function
Hi Group,
Just wanted to do
Hi Group,
Just wanted to double check that the 'Maximum' function can only do
comparison between 2 fields? It works for me when I use 2, but I want
to find the highest value in each record using a criteria of 7 fields.
Any other ideas on how to do this? Thanks,
Christine
Christine Ronning
GIS
Hello,
Has anyone out there used autocad map 3d? how does the GIS component
compare with Mapinfo.
cheers
Scott
-
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL
I logged on to an old laptop for the first time. (It's had MI 6.5 on it
for sometime & was used by others.) I opened MI, it started an install
(of sorts), then opened MI with the error. Now when I open MI, I get
the error. Everything seems to work after I click "OK". From looking
at the "old
I've got a district description that's in terms of named townships in
Madison and St. Claire counties in Illinois, and I need to create a
polygon of its boundary. I found the township polygons at
http://www.isgs.uiuc.edu/nsdihome/ISGSindex.html, but they are identified
only by their township-range
Thank you that's good information I'll keep in mind.
Marty
-Original Message-
From: Uffe Kousgaard [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 10:50 AM
To: Mapinfo-L
Subject: Re: MI-L Query field properties
Note on this:
As soon as you apply the format$() function, the orig
Note on this:
As soon as you apply the format$() function, the original full accuracy
number is turned into a string with only 6 decimals and the rest is lost
"for ever".
As long as MapInfo shows the number with 3 decimals, the rest of them is
still there behind the scenes and ready to be us
That's fantastic! Thanks
_
From: Driver, Greg 9434 [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 10:44 AM
To: Sprenz, Marty; Mapinfo-L
Subject: RE: MI-L Query field properties
You could use Format$() -
format$((val(Mid$(LONGITUDE,3,3)) + (val(Mid$(LONGITUDE,6,7)) / 6
You could use Format$() -
format$((val(Mid$(LONGITUDE,3,3)) + (val(Mid$(LONGITUDE,6,7)) / 60 )) *
(-1), "#.##")
Greg.
-Original Message-
From: Sprenz, Marty [mailto:[EMAIL PROTECTED]
Sent: 28 July 2005 16:24
To: Mapinfo-L
Subject: MI-L Query field properties
Is there a way to fo
Is there a way to format the properties of a field in a query? The function
that Uffe helped me with is great but it only goes out to the 3rd decimal
place. I need it to go to the 6th decimal place.
Cingular Wireless
Marty Sprenz (RF Engineer - Contractor)
100 Concourse Pkwy
Birmingham, A
I forgot about val. Thank you for taking time out of your day to answer my
silly questions.
Marty
-Original Message-
From: Uffe Kousgaard [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 9:57 AM
To: Mapinfo-L
Subject: Re: MI-L Data type mismatch
mid$ returns a string and you can
mid$ returns a string and you can't divide that by 60:
(( val(Mid$(LONGITUDE,3,3)) + val(Mid$(LONGITUDE,6,7)) / 60 ) * (-1)
Kind regards
Uffe Kousgaard
www.routeware.dk
- Original Message -
From: "Sprenz, Marty" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 28, 2005 4:51 PM
Subject:
Hello again, I'm getting a data type mismatch error with the following sql
statement: ((Mid$(LONGITUDE,3,3)+(Mid$(LONGITUDE,6,7)/60))*-1) "LONGITUDE".
I broke down the statement and the problem is to the right of the plus sign.
The value of the field looks like this: W 11521.0460. I need to get r
That works. It never occurred to me to remove the as.
Thanks!!
-Original Message-
From: Ben A Greenberg [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 8:56 AM
To: Sprenz, Marty; MapInfo-L@lists.directionsmag.com
Subject: RE: MI-L RE: Alias Field Names In a MI Query
Try this:
Try this:
Select fldValue1 "fldThisNewFieldName"
Where fldValue1 > 1
Into tblNewTableName
Ben Greenberg
GIS Coordinator
NAI MLG Commercial
262-797-9400
-Original Message-
From: Sprenz, Marty [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 8:59 AM
To: MapInfo-L@lists.dire
Hello,
I am trying to create a query that has, I believe it's called, alias field
names.
Example:
Select fldValue1 as fldThisNewFieldName
Where fldValue1 > 1
Into tblNewTableName
Just so I'm clear, the result of the query would be a new table named
tblNewTableName with one field called
Hi,
Does anybody know how to read and put DEGREE coordinates form map objects into
variable? I can read only metric coordinates in mapbasic using
'objectgeography'.
Tomasz
I save those type of files as a .dbf file from MapInfo. Since Excel can
read .dbf files I just open it in Excel... and save it as an .xls file
from there...
I'm not sure of any other way to save it DIRECTLY from MapInfo to
Excel...
tim
-Original Message-
From: Sasidhar [mailto:[EMAIL PR
I agree, those VBA samples could be quite useful.
Another thing that could make the Format$() function better is if it actual
would return the number of decimals that you ask for.
Check these examples:
Print Format$(123.2345, "#.###")
Returns correctly 123.234
Print Format$(123.23, "#.##
Hi listers
can anybody please tell me how a dbf file can be saved as an excel file from
mapbasic.
my requirement is to get the table structure of a selected table into an excel
file.i could get the table structure into a dbf file.NOw i want to save this
dbf file as a n excel file.
or is ther
Dates seem to cause a lot of labeling difficulties since each person prefers
to display the same information differently. In fact, your supervisor or
client may want a specific display. One is forced to employ the Left$, Mid$
and Right$ functions on long strings in order to obtain different date
Dear All,
Unless I'm missing a really obvious trick here I'm looking for help in
converting a point file into a text file.
I've converted a shapefile through universal translator, but instead of
creating a text attribute, it places a point where the text should be,
however I need the text displaye
Hi listers,
I have a client who has asked me
"Every time I kick the upgrade off we get an error as it cannot access
ncsecw.dll"
Any ideas what its trying to do? Isn't ecw a compression format thing?
Any help would be appreciated
TIA
Nick Hall
~~ INDEPENDENT GIS CONSULTANCY AND TRAINING ~
Andrew,
You can use the Thin function to remove nodes that are close to each other or
in line. This would be the way to proceed:
Select the boundaries
Choose the menu item Objects > Snap/Thin
Now you can specify a large distance. This will remove many of your nodes. I
guess you'll have to try a
Dear All
I have five polygon boundaries, which I am creating a SVG file for (using
MAP2SVG), the SVG file that is created is about 8 pages long due to the
complexity of the boundaries. Is there anyway within MapInfo to remove a
certain percentage of nodes used within a boundary?
If I can remo
Mike,
You always have to Year(), Month and Day() function to help you formatting the
date in just the way you want.
In your case this would do the trick:
Right$("00" + Month(DATE), 2) + "/" + Right$("00" + Day(DATE), 2) + "/" +
Year(DATE)
HTH,
Peter Horsbøll Møller
GIS Developer, MTM
Geograph
27 matches
Mail list logo
