Does someone know a sql statement that allows me to add an incremental number to a
table? I have a list of 60 things and I want to number them starting from 1-60. Or is
there another way to do this in MapInfo?
Willie Wangberg
Information Technology
Rio Tinto Exploration
52 Glen Carran Circle
Sp
Group
I have a Interstate shield's layer for the U.S. that has a shield (node)
every mile along that Interstate. What I want to do is make the same layer
but, only have nodes that are 5 miles apart. Any ideas on how to do this?
Thanks for any help.
---
Hi guys
I have a dataset that contains a field with references like 1/375 and
2/540 etc. I need to update another column with the just number
preceeding the /. Is there any way I can do this using an SQL. The
dataset is huge and im trying to save some time rather than going
through and manually
Hi listers
I have two MI tables, one contains postcode (Zipcode) boundaries and the
other contains points that are attributed with a crime type e.g. 'C1', 'C2',
'C3' etc.
What I require is a query that can count the number of each crime type that
fall within each postcode boundary so that I can
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi all,
I have what I thought would be an easy query but it is giving me problems. I
have 2 street files, one new and one old. They have roughly the same
struc
I have a table with two columns one called numbers one called groups. In
the table certain numbers like 2 fall within multiple groups. How do I get
MapInfo to grab just the numbers that are within more than one group?
Travis Lathrop
Intercarrier Services
913/762-4806
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi All,
I am trying to select all the streets in my street table that are within
5kms of a city file. The city file is a point file while the street file is
ob
Tel +41 (0)31 368 0180 - Fax +41 (0)31 368 1860
-Original Message-
From: "Wangberg, Willie (USBORAX)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Fri, 22 Oct 2004 09:15:55 -0700
Subject: MI-L SQL
OTECTED]
Sent: Monday, December 08, 2003 8:31 PM
To: [EMAIL PROTECTED]
Subject: MI-L SQL Help
Hi guys
I have a dataset that contains a field with references like 1/375 and
2/540 etc. I need to update another column with the just number
preceeding the /. Is there any way I can do this using an SQ
Carolyn,
Use the Instr function in combination with the Left$ function
Instr(1,"123/456","/") returns 4, which is the chanacter position of the
"/"
So,
Update TableName Set FirstPart = left$(Data,InStr(1,Data,"/")-1)
will update the column FirstPart in table Tablename with everything
before th
Mitchell Geographics, Inc.
> 496 Congress Street
> Portland, Maine 04101
> 207.879.7769
> www.mitchellgeo.com
>
>
> -Original Message-
> From: Carolyn Bergin [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 08, 2003 8:31 PM
> To: [EMAIL PROTECTED]
>
You can then use this table to do your thematic maps.
HTH
Regards
martin
- Original Message -
From: "Burchfield, Robin 10088" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 12, 2004 11:12 AM
Subject: MI-L SQL Help
> Hi listers
>
>
rrier, Steve [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 10:13 AM
To: '[EMAIL PROTECTED]'
Subject: MI-L SQL Help
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi all,
I have what I t
, 2002 12:13 PM
To: 'Morrier, Steve'; MapInfo-L (E-mail)
Subject: RE: MI-L SQL Help
Steve,
Not to worry, you won't get fired. Remember we are the ones who actually do
the work!
Here is a method for selecting records in one table that do not match
records in another table.
Consi
[EMAIL PROTECTED]cc:
Carolyn,
Use the table> Update Column menu item and set it up so that you use
this expression to update your new field.
Left$(OldField,Instr(1,"/",OldField)-1)
r
On Tue, 9 Dec 2003 12:31:15 +1100, Carolyn Bergin
<[EMAIL PROTECTED]> wrote:
Hi guys
I have a dataset that contains a field wi
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 15 March 2005 15:16
To: Terry McDonnell
Subject: MI-L SQL help?
Group
I have a Interstate shield's layer for the U.S. that has a shield (node) every
mile along that Interstate. What I want to do is make the same layer but, only
17 matches
Mail list logo