BTW, don't forget to include the NOFILTER keyword in your SQL SELECT statement. Otherwise, you may end up making changes to data in a filtered view of the source table instead of a separate table.

Liam




>USE DBF("c_temp") IN 0 AGAIN ALIAS myUpdatable_c_temp
>SELECT myUpdatable_c_temp
>REPLACE ALL ;
>company WITH "bla bla bla"