Philip
If your Shield nodes are identified numbered sequentially, e.g. ShieldNo,
beginning at 1, then you could probably do:
Select * from ShieldLayer where ShieldLayer.ShieldNo MOD 5 = 0
That should get every 5th shield, so every 5 miles.
HTH
Terry McDonnell
-Original Message-
hi willie
table / update column, use rowid as value.
Mit freundlichem Gruss / Best Regards
Flavio Hendry
TYDAC NEWS http://www.tydac.ch/german/index.php?menu=News_actual
Hi Robin,
first you need to do a bit of SQL to get the counts of crime types
POSTCODETABLE = Postcode boundary table name
CRIMETYPETABLE = Crime type table name
Select POSTCODETABLE.POSTCODE, CRIMETYPETABLE.CRIMETYPE, Count(*)
From POSTCODETABLE, CRIMETYPETABLE
Group by 1,2
Order by 1,2
You
Hi Carolyn,
There's surely a way to do this using the / as a separator, but in my
limited ways I use the Left$() function. Trick is you have to have the same
number of places each time, so if your numbers grow you'll have to do it
multiple times on fixed width subsets.
You can update your other
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 the first
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 with
note our new telephone, direct and telefax numbers.
COWI wish you a merry Christmas and a happy New Year.
-Original Message-
From: Will Mitchell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 2:58 AM
To: Carolyn Bergin; [EMAIL PROTECTED]
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.
Consider a situation where we must find all the records in TableA whose
values in FieldA do not match the
, 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.
Consider a situation
:
onsmag.com Vedr.: RE: MI-L SQL Help
10 matches
Mail list logo
