Erin
Something like (assuming you've located the 2 records in question):
DIM loObj as Object,
lnRowId as Integer
...
loObj = SourceTable.Obj
lnRowID = DestTable.RowID
Update DestTable
set Obj = loObj
Where RowID = lnRowID
Terry McDonnell
-----Original Message-----
From: Erin Scanlon [mailto:[EMAIL PROTECTED]
Sent: 14 October 2005 19:16
To: Terry McDonnell
Subject: MI-L Need to update obj in table1 with obj from table2?
I have two tables and I need to update the obj in one with the obj from
the second. There is an corresponding field of STORE_NUM which is a
character field in both tables. Can anyone help please?
Erin Scanlon
GIS Specialist
Market Research
Phone: (401) 468-2637
CONFIDENTIALITY WARNING
This message, including its attachments, is strictly intended for the
use of the individual or the entity to which it is addressed and
contains privileged and confidential information. Disclosure,
distribution or copy of this communication is strictly prohibited. If
you are not the intended recipient please notify us immediately by
returning the e-mail to the originator and deleting all copies.
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 18317
