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
-
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 query
and it selected
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 = Table
: [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 sql select statement-
Select * from Table A, Table B where Table
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
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 possible to do, if so could
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
-
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 multiply
@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.
Thanks
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
column
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 elevation values
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
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
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
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's hanging up the SQL
select.
Thanks to Mike Cummings also for his
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
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
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$(obj),line)
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 I
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 table and one
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]
cc:
Vedr.: RE: MI-L SQL Select
I used once in the SQL requester that where condition
instr(1,Col_Name
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
-
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 the polygons and update
that
count in the polygon
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
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 within Radius
Date: Fri, 1 Jun 2001 13:21:09 -0400
Help! Why won't this work
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.
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 syntax for selecting on those re
"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 Steve!
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 an SQL select bug. When I want to select all the =
p
tion
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 the
"FROM&
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
32 matches
Mail list logo