MI-L SQL help

2004-10-22 Thread Wangberg, Willie (USBORAX)
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

MI-L SQL help?

2005-03-15 Thread Philip . Lesnik
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. ---

MI-L SQL Help

2003-12-08 Thread Carolyn Bergin
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

MI-L SQL Help

2004-02-12 Thread Burchfield, Robin 10088
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

MI-L SQL Help

2002-02-28 Thread Morrier, Steve
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

MI-L SQL help

2001-04-13 Thread Lathrop, Travis
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

MI-L SQL Help

2001-08-28 Thread Morrier, Steve
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

Re: MI-L SQL help

2004-10-22 Thread Flavio Hendry
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

RE: MI-L SQL Help

2003-12-08 Thread Will Mitchell
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

Re: MI-L SQL Help

2003-12-08 Thread Matt Bolton
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

RE: MI-L SQL Help

2003-12-08 Thread Peter Horsbøll Møller
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] >

Re: MI-L SQL Help

2004-02-12 Thread Martin Hodder
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 > >

RE: MI-L SQL Help

2002-02-28 Thread Fast, Tim
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

RE: MI-L SQL Help

2002-02-28 Thread Morrier, Steve
, 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

RE: MI-L SQL Help

2002-02-28 Thread PEM
[EMAIL PROTECTED]cc:

Fwd: Re: MI-L SQL Help

2003-12-08 Thread Robert Crossley
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

RE: MI-L SQL help? - Shield Nodes

2005-03-16 Thread Terry McDonnell
- 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