AW: MI Table update column command

1999-07-02 Thread Andreas Mahn

Tony,

the way that I would go is a SQL query joined on the ID, with the
properties table listed first in the From clause. This will return the
property regions together with all required attribute data.

Cheers,
Andreas
.
Andreas Mahn
dds GmbH
Stumpfstr.1 
76131 Karlsruhe
Germany
Tel.: +49 - (0)721 - 9651406
Fax: +49 - (0)721 - 9651419
http://www.dds.ptv.de/

...
[EMAIL PROTECTED]

>--
>Von:   Tony Shepherd[SMTP:[EMAIL PROTECTED]]
>Gesendet:  Donnerstag, 1. Juli 1999 01:14
>An:MapInfo Email Group (E-mail)
>Betreff:   MI Table update column command
>
>Using the "update column" command off the table menu can you add a
>temporary column that is a object from another table.
>For example I have a table of properties, with a region and a property
>ID. I have another table with names of people and a property ID. I want
>to copy all the objects from the property table to my names table only
>where there is a match between property ID's.
>I have written MapBasic code to do this but I am curious if it can be
>done straight from MI?
>Cheers
>Tony 
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - 
>  Tony Shepherd, GIS / IT Support
>Gore District Council, Gore, New Zealand
>Gore, The Brown Trout Capital
>
>   .. .. .. .. check it out! .. .. .. ..
>  .. . www.mataura.com . ..
>- - - - - - - - - - - - - - - - - - - - - - - - - - - 
>
>--
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI Table update column command

1999-06-30 Thread Tony Shepherd

Using the "update column" command off the table menu can you add a
temporary column that is a object from another table.
For example I have a table of properties, with a region and a property
ID. I have another table with names of people and a property ID. I want
to copy all the objects from the property table to my names table only
where there is a match between property ID's.
I have written MapBasic code to do this but I am curious if it can be
done straight from MI?
Cheers
Tony 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - 
  Tony Shepherd, GIS / IT Support
Gore District Council, Gore, New Zealand
Gore, The Brown Trout Capital

   .. .. .. .. check it out! .. .. .. ..
  .. . www.mataura.com . ..
- - - - - - - - - - - - - - - - - - - - - - - - - - - 

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]