Dear All
This may be a easy one but hear goes, I have two columns of data which I want
to multiply the values of each together and give the result in a additional
column. I take it this is possible to do, if so could somebody please enlighten
me.
Thanks
Andrew Tracey
Information Support Offic
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,
Is there a simple way to select the records in the same table that have =
the
same name and the same second variable? I want to be able to select all
s
I have two tables, one contains points, the other polygons. I want to
find out how many points are within each of the polygons and update that
count in the polygon table. I'm drawing a blank on this one.
Thanks,
Christian McNierney
Spatial Insights, Inc.
A Geographic Information Services
Does anybody know the proper syntax for selecting on those records within a
field that contain two words or more. I need to select all street names with
in a file that are more than one word. Basically I am concerned with any
entry that has a space in it. Any help would be greatly appreciated. Tha
List,
I'm having a problem with a selection query. I have 2 tables both editable with a common column named "ID". Table B is my "deleted" records which I want to find in table A to delete. When I run the following sql select statement-
Select * from Table A, Table B where Table A.ID = Ta
Dear list,
We have a database with elevation values of contourlines with an
aquidistance of 1m. Now we want to select lines with an interval of
5m.
So we tried the sql select function:
table: the contour table
column: the elevation values
where condition:
And here we stuck. Can someone give u
riginal Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Tracey
Sent: Monday, November 28, 2005 6:19 PM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Select
Dear All
This may be a easy one but hear goes, I have two columns of data which I want
to multi
fo-L@lists.directionsmag.com
Subject: [MI-L] SQL Select
Dear All
This may be a easy one but hear goes, I have two columns of data which I
want to multiply the values of each together and give the result in a
additional column. I take it this is possible to do, if so could
somebody please enlighten me.
Th
ey
Sent: 28 November 2005 17:19
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Select
Dear All
This may be a easy one but hear goes, I have two columns of data which I want
to multiply the values of each together and give the result in a additional
column. I take it this is possibl
Hi,
I am using SQL Select to sum object lengths. The selection table has
one column from the base table and one derived column. The derived column
is specified as Sum(ObjectLen(obj,"ft"))
I get this error: "Could not fetch object from the current row, argument
ObjectLen"
The query
O.K.
I tried using the table name with the expression for the ObjectLen function
as Terry McDonnell suggested..got the same result.
Then I checked to see if these are in fact polylines as Bill Thoen
suggested. All of the lines where selected meaning none are polylines. I
even reversed this
Thanks Spencer, that helped a lot. I was able to determine that 13 out of
893 objects were in fact not polylines and this is what's hanging up the SQL
select.
Thanks to Mike Cummings also for his suggestion, however I had already
packed the table when I first got the error.
Donald Guerra
ginal Message -
From: "Christian McNierney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 18, 2002 9:17 PM
Subject: MI-L SQL Select
> I have two tables, one contains points, the other polygons. I want to
> find out how many points are within each of th
rence på
http://www.kampsax-gis.dk/Default.asp?ID=296
"Jacques Paris" <[EMAIL PROTECTED]>
Sendt af: [EMAIL PROTECTED]
09-03-2001 20:58
Besvar venligst til "Jacques Paris"
Til:"Morrier, Steve" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]&g
I think this may be an SQL select bug. When I want to select all the =
points from a point layer that fall within a polygon layer using SQL =
select, sometimes it selects only polygons and sometimes it selects the =
points. I can't seem to figure out exactly how to get it to select only =
the po
uestions see the J.Paris site at
http://www.total.net/~jakesp/index.htm
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Morrier, Steve
Sent: March 9, 2001 2:36 PM
To: '[EMAIL PROTECTED]'
Subject: MI-L SQL Select
Does anybody know the proper synt
"Morrier, Steve" wrote:
>
> Does anybody know the proper syntax for selecting on those records within a
> field that contain two words or more. I need to select all street names with
> in a file that are more than one word. Basically I am concerned with any
> entry that has a space in it.
Hi St
9:22 AM
To: mapinfo-l@lists.directionsmag.com
Subject: [MI-L] sql select
List,
I'm having a problem with a selection query. I have 2 tables both editable with a common column named "ID". Table B is my "deleted" records which I want to find in table A to delete. When I run the following
Message-
From: Robert DeRubeis
[mailto:[EMAIL PROTECTED]
Sent: Friday, 14 April 2006 1:43
AM
To:
mapinfo-l@lists.directionsmag.com
Subject: Re: [MI-L] sql select
That's what the problem was. Table A was not mappable
and Table B was mappable. I made Table A mappable and ran the same quer
dSendt: 18. april 2006 02:58Til:
Robert DeRubeis; mapinfo-l@lists.directionsmag.comEmne: RE: [MI-L]
sql select
Robert,
Another way, that
works regardless of whether or not either table is mappable is a query of this
form:
Tables
{TableA}
Where {ID in (select
ID f
On Sat, 17 Jul 2004, Véronique De Laet wrote:
> We have a database with elevation values of contourlines with an
> aquidistance of 1m. Now we want to select lines with an interval of
> 5m.
If you want to select contour lines with elevation values that are even
multiples of 5m, you can do so
CTED]
Sent: 17 July 2004 20:30
To: [EMAIL PROTECTED]
Subject: MI-L sql select problem
Dear list,
We have a database with elevation values of contourlines with an
aquidistance of 1m. Now we want to select lines with an interval of
5m.
So we tried the sql select function:
table: the contour table
c
Sorry, missed Bill's answer!
-Original Message-
From: Bill Thoen [mailto:[EMAIL PROTECTED]
Sent: 17 July 2004 22:18
To: Véronique De Laet
Cc: [EMAIL PROTECTED]
Subject: Re: MI-L sql select problem
On Sat, 17 Jul 2004, Véronique De Laet wrote:
> We have a database with e
If you cannot use the MOD function, use the statement WHERE: INT(ELEVATION/5) =
(ELEVATION/5)
This works well
Have luck
SERGI
-Mensaje original-
De: Véronique De Laet [mailto:[EMAIL PROTECTED]
Enviado el: sábado, 17 de julio de 2004 21:30
Para: [EMAIL PROTECTED]
Asunto: MI-L sql select
I am attempting to join two tables together (one mapinfo table and one database table)
based on a primary key of postcode. On one table it is a number, in the other table
it is a string. When trying to join the two through SQL Select, the obvious error
message appears "Datatype mismatch". If
"str$(obj)" for a polyline returns "Polyline", not "Pline".
In addition, there is a "line" object type for which str$(obj)
returns "line".
You can use either of the two expressions below to search for
rows that are neither lines nor polylines:
not (str$(obj)=any ("line", "polyline"))
instr(1,str
ning/index.htm
-Original Message-
From: Don Guerra [mailto:[EMAIL PROTECTED]
Sent: March 17, 2004 10:27
To: MapINFO (MapINFO)
Subject: MI-L SQL Select Error
Thanks Spencer, that helped a lot. I was able to determine that 13 out of
893 objects were in fact not polylines and this is what'
vid Booth
Senior GIS Officer
Merseyside Information Service
> -Original Message-
> From: Richard Maaranen [SMTP:[EMAIL PROTECTED]]
> Sent: 07 February 2001 00:05
> To: [EMAIL PROTECTED]
> Subject: MI-L SQL select bug?
>
>
>
> I think this may be a
hope this helps
Jon
-Original Message-
From: David Booth [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2001 09:16
To: 'Richard Maaranen'; [EMAIL PROTECTED]
Subject: RE: MI-L SQL select bug?
Hi Richard,
I'm pretty sure this will be down to the order you list the tables in
tement. I think (though I'm not entirely sure) that
> you get the objects from the first table in the list. Possibly.
>
> -
> David Booth
> Senior GIS Officer
> Merseyside Information Service
>
> > -Original Message-
> > From: Richard Maaranen [SMTP:
Help! Why won't this work? It used to!
Select Location, sum(price), sum(cost)
from anytable
where anytable.obj within CreateCircle(CentroidX(obj),CentroidY(obj),"50")
group by Location
order by Location
into Selection
Steve Wallace
Florida Farm Bur
d capacity for learning from mistakes, so they may be completely
false.
-Original Message-
From: Peter Brown [mailto:[EMAIL PROTECTED]
Sent: Monday, 28 July 2003 2:43 PM
To: [EMAIL PROTECTED]
Subject: MI-L SQL Select Join Problem
I am attempting to join two tables together (one mapinfo tab
: 01 June 2001 18:21
To: [EMAIL PROTECTED]
Subject: MI-L SQL Select within Radius
Help! Why won't this work? It used to!
Select Location, sum(price), sum(cost)
from anytable
where anytable.obj within
CreateCircle(CentroidX(obj),CentroidY(obj),"50")
nt to change this back is:
set map distance units "mi"
Cheers,
Chris
Chris DuBuc
[EMAIL PROTECTED]
>From: "Steve Wallace" <[EMAIL PROTECTED]>
>Reply-To: "Steve Wallace" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: MI-L SQL Select
Hi List
I have 2 tables: Route and Journey
Journey is a superset of Route in that 1 route (bus) may feature several
journeys (e.g. the same route but individual details of each journey,
such as its times, whether it operates on public holidays, et al)
Now Journeys can have service categories
35 matches
Mail list logo