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
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
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 for
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 -
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 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
ht
"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
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 r
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
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
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
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
"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
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
ta
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
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
.e.
>
> select *
> frompoints, polygons
> where points.obj within polygons.obj
> group
> order
> intoselection
>
> hope this helps
>
> Jon
>
> -Original Message-
> From: David Booth [mailto:[EMAIL PROTECTED]]
> Sent: 07 February 2001
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 existin
Steve,
Just a stab in the dark, but do you need to add the 'ANY' keyword in the
select statement?...
where anytable.obj within Any
CreateCircle(CentroidX(obj),CentroidY(obj),"50")
Keith
-Original Message-
From: Steve Wallace [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 18:21
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 chang
20 matches
Mail list logo