Hello Steve,
Do the records (rows), both in the original and edited tables, have a common
identifier? For instance, a column with a unique record code or name. If
so, I believe you could go about in two ways depending on how many columns
you changed information.
If it is only 1 or 2 columns, then you may do a Table => Update Column;
Table to Update = OriginalTable, Get Value from Table = EditedTable; Join
where OriginalTable_UniqueColumn matches EditedTable_UniqueColumn; then
choose the source and target columns.
If there are many columns involved, you may do a Query => Select on the
original table using the unique value as parameter and cut those records
out. Do the same query on the edited table and append the selected records
to the original table. For this to work, the two tables must have the same
structure. Packing your tables after eliminating and adding records is a
good idea but it will mess columns with row id's.
Probably it would be best to do it first on copies of both tables.
Hope this helps.
Miguel Iturralde
----- Original Message -----
From: "Morrier, Steve" <[EMAIL PROTECTED]>
To: "MapInfo List (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, 25 April, 2001 08:43 AM
Subject: MI-L Table Update
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
>
> I have done a SQL to select the records from a large table that I wanted
to
> edit. I needed to temporarily change the table structure so I did a save
> copy as.... After doing the edits and returning the table structure to
it's
> original format how do I add the new rows back to the original table so
that
> they overwrite the rows I edited? Thanks
>
> Steve
>
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
