This is a really strange one that I haven't been able to understand either (presumably
Works As Designed??)
The simple solution is to select those that match first then update the query only
rather than the whole table.
Mark Knudsen
__________________________________________________________________
Veitch Lister Consulting Pty Ltd Phone: +61 3 9427 7400
Suite 14 663 Victoria Street Fax: +61 3 9427 0481
ABBOTSFORD VIC 3067 email: [EMAIL PROTECTED]
__________________________________________________________________
-----Original Message-----
From: Karen Behm
Sent: Thursday, October 14, 1999 3:37 AM
To: '[EMAIL PROTECTED]'
Subject: MI Update Column
Hi all
I've been confused lately. I need to update one column with data from
different data sets. How can I do this without overwriting previous data?
I can do the first column update just fine, then I go to update the same
column with my 2nd data set and that is completed fine, only the records
updated from the first data set become blank. The actual records updated
are different with each data set.
I am sure this is something simple, so I am looking forward to your
responses.
Karen
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
