Mapinfo is looking for a value. You need to assign an alias for the object in T2 & use the rowID for each table.
dim o_t2 as alias dim i_t1, i_t2 as integer o_t2=T2.obj i_t1=t1.rowid i_t2=t2.rowid do while not eot(T1) update T1 set obj=o_T2 where i_t1=i_t2 loop -----Original Message----- From: Pablo Ramos [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 3:37 AM To: [EMAIL PROTECTED] Subject: MI-L Copying objs from one table to another Hi listers, well my question is next, i have a Mapbasic program which has two tables named T1 and T2. I want to update the field T1.obj with the value in the field T2, the logical instruction would be: UPDATE T1 SET T1.obj = T2.obj but Mapinfo throws an exception saying that variable or field T2.obj not defined ¿What can i do? ¿Any answer? Thanks, thanks, thanks to everybody. --------------------------------- --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12913