There's also a shareware mbx created by Ahmet DABANLI (Middle East Technical
University,
Ankara Water and Wastewater Administration, Ankara / Turkiye) downloadable
from: http://www.directionsmag.com/tools/ (search for Sel_NUpt.zip)
that allows you to select records by selecting values from a drop down menu
populated with unique values from any column, and update table with a
criteria in same dialog (without having to update selection).
Thanks,
Erin Rubio
Spatial Insights, Inc.
A Geographic Information Services Company
8221 Old Courthouse Road Suite 203 Vienna, VA 22182
Tel: 703-827-7034 Fax: 703-827-7037
Sales: 800-347-5291
[EMAIL PROTECTED] www.spatialinsights.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bull, Leo
Sent: Sunday, September 17, 2000 10:37 PM
To: 'MAPINFO-L@csn. net . ' (E-mail)
Subject: MI Column Update
Hello All
Thankyou to Chris Perry, Butian Wang and Jacques Paris for their quick
replies. It has solved my problem.
Chris Perry's response was:
I advise making a backup copy of your table first!
First of all, select the rows which have column_A as blank (Query > SQL
Select):
Select *
from TABLE
where column_A=""
You will return a table called selection which only has these records, now
use Table > Update Column to update this selection
Update table: Selection
Column to update: Column A
Update with: Column_B
Kind regards
Leo Bull
GTFP
Mt Gambier
South Australia
----------------------------------------------------------------------
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]
