SV: [MI-L] sql select

2006-04-18 Thread Watertech - Jacob K . Jørgensen
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

RE: [MI-L] sql select

2006-04-17 Thread Llewellyn, David
- 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

[MI-L] sql select

2006-04-13 Thread Robert DeRubeis
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

Re: [MI-L] sql select

2006-04-13 Thread Robert DeRubeis
: [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

[MI-L] SQL select not performing as expected

2006-01-31 Thread Terry McDonnell
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

RE: [MI-L] SQL Select

2005-12-03 Thread Lawley, Russell S
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

[MI-L] SQL Select

2005-11-28 Thread Andrew Tracey
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

RE: [MI-L] SQL Select

2005-11-28 Thread Peter Horsbøll Møller
- 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

RE: [MI-L] SQL Select

2005-11-28 Thread Jakob Lanstorp
@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

RE: MI-L sql select problem

2004-07-19 Thread Dominic Lowe
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

RE: MI-L sql select problem

2004-07-19 Thread Dominic Lowe
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

RV: MI-L sql select problem

2004-07-19 Thread Gamiz Ribelles, Sergi (Regsa)
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

MI-L sql select problem

2004-07-17 Thread Véronique De Laet
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

Re: MI-L sql select problem

2004-07-17 Thread Bill Thoen
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

RE: MI-L SQL Select Error

2004-03-19 Thread Woody Woodruff
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

MI-L SQL Select Error

2004-03-17 Thread Don Guerra
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

MI-L SQL Select Error

2004-03-16 Thread Don 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

MI-L SQL Select Error

2004-03-16 Thread Don Guerra
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

RE: MI-L SQL Select Error

2004-03-16 Thread Spencer Simpson
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)

MI-L SQL Select Join Problem

2003-07-28 Thread Peter Brown
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

RE: MI-L SQL Select Join Problem

2003-07-28 Thread Simmonds, Ashley (PTB)
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

RE: MI-L SQL Select

2002-06-26 Thread jal
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

MI-L SQL Select

2002-03-18 Thread Christian McNierney
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

Re: MI-L SQL Select

2002-03-18 Thread Uffe Kousgaard
- 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

MI-L SQL Select

2002-03-06 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, 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

Re: MI-L SQL Select within Radius

2001-06-09 Thread Chris DuBuc
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

MI-L SQL Select

2001-03-09 Thread Morrier, Steve
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.

RE: MI-L SQL Select

2001-03-09 Thread Jacques Paris
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

Re: MI-L SQL Select

2001-03-09 Thread Mats Elfström
"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!

RE: MI-L SQL select bug?

2001-02-07 Thread David 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 an SQL select bug. When I want to select all the = p

RE: MI-L SQL select bug?

2001-02-07 Thread Stokes Jonathan
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&

MI-L SQL select bug?

2001-02-06 Thread Richard Maaranen
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