On 3 Feb, Ian Macey wrote:
> I am trying to update the column of a table which contains about 200 records
> stored in date format. Rather than just cutting and pasting new dates into
> every cell, is there a way to select all and update with a new date (the
> same in every cell).
I will assume the column name is DATE and the table name is MYTABLE and
the date you want all the rows set to is 1/1/99. In a MapBasic window
type the following:
update MYTABLE set DATE = "1/1/99"
> Also is there a way to select all, with for example the date 4/2/99 and
> replace with 5/3/99 or is it better to export into excel to do this and
> bring the table back in?
>
update MYTABLE set DATE = "5/3/99" where date = "4/2/99"
These update statments are standard SQL which MapInfo understands.
--
-----------------------------------------------------------------------
Roy Stewart Global Atmospherics Inc.
Applications Developer Manufacture and systems integrator of lightning
[EMAIL PROTECTED] location and detection equipment and services
Phone: (520) 741-2838
2705 E. Media Rd. Fax: (520) 741-2848
Tucson AZ 85706-7155 Web: http://www.glatmos.com
How intelligent is it,
to start the day by tying a noose around your neck?
-----------------------------------------------------------------------
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
