RE: [MI-L] sql select

- 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

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 the records from Table A. Thanks for the help. -Bob Mike Mayer [EMAIL PROTECTED] on Thursday, April 13, 2006 at 9:46 AM -0700 wrote: Are the

RE: [MI-L] SQL Select

andy you dont say if you just want a query to do this or an update (answers so far have been update based.. which is ok if you have a column ready to fill..if noy then you have teh hassle of altering teh table structure etc etc.. I tend to do this kinda stuff as a query so setup the QL

RE: [MI-L] SQL Select

Andrew, - Goto Table Update Column - Select the table you want to update - Select the column to update - In the value field you enter this: COLUMNNAME1 * COLUMNNAME2 where COLUMNNAME1 is the name of the first column and COLUMNNAME2 is the name of the second table Peter Horsbøll Møller

RE: [MI-L] SQL Select

Update MYTABLE SET MYCOLPRODUCT = MYCOL1 * MYCOL2 If you have a large dataset you might first what to run the following line in the mapbasic window: Set Table MYTABLE FastEdit On Undo Off HTH, Jakob Lanstorp Software Consultant Geographical Information IT COWI A/S Odensevej 95 DK-5260 Odense

RE: MI-L sql select problem

The Mod keyword might be what you need. i.e. SELECT * FROM ContourTable WHERE ElevationColumn MOD 5 = 0 This will return all values of Elevation that can be divided exactly by 5. Hope that helps, Dominic -Original Message- From: Véronique De Laet [mailto:[EMAIL PROTECTED] Sent: 17

RE: MI-L sql select problem

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

Re: MI-L sql select problem

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

I find myself adding this AND clause to just about any spatial query I use- Region may also be Line, Pline, etc, however, region is most common way to use it. The table it needs to reference is the one with the objects you are using to select with, not needed for the objects of the target table.

RE: MI-L SQL Select Error

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)

RE: MI-L SQL Select Join Problem

as far as i'm aware a JOIN requires the same fundamental data type, a WHERE statement does not, so long as they're processed as the same data type. confuserating i know, but a JOIN is interpreted slightly differently in SQL, it is more of a hardcoded response where it can take advantage of

RE: MI-L SQL Select

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

Re: MI-L SQL Select

Go to Table Update Column and fill in the appropriate fields: If you open a mapbasic window first, the result should look like this: Add Column polygontable (countfield) From pointtable Set To Count(*) Where within Kind regards Uffe Kousgaard www.routeware.dk - Original Message -

Re: MI-L SQL Select within Radius

Hi Steve, I've had a similar problem using the createcircle function in the SQL dialog. It turned out the problem was with the current distance units setting in the map windowa previous statement of mine had changed the units to meters from miles. I believe the mapbasic statement to

RE: MI-L SQL Select

I used once in the SQL requester that "where" condition instr(1,Col_Name," ")0 JP Jacques PARIS e-mail (19.12.00) [EMAIL PROTECTED] For MapInfo support, see the Paris PC Consult enr. site at http://www.total.net/~rparis/gisproducts.htm For MapBasic questions see the J.Paris site at

Re: MI-L SQL Select

"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?

Hi Richard, I'm pretty sure this will be down to the order you list the tables in the "FROM" bit of the SQL statement. 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

RE: MI-L SQL select bug?

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&