> not very familiar with foxpro -- just trying to port a program to a different language. could someone tell me what the change to table2 will be following these statements?
>
> select table1
> select table2
> append from table1
> replace all table2.commfac with table1.commfac_1
>
> assume tables as follows:
>
> table1: fields fileno, commfac_1
>
> 100 34.2
> 101 33.9
> 102 12.4
>
> table2: fields fileno, commfac
>

* would something like this work for you?

SELECT table1
COPY TO table2
ALTER TABLE table2 RENAME COLUMN Commfac TO Commfac_1