>Hi Deamon
>
>You should put ALL after REPLACE:
>
>REPLACE table2.field1 WITH table1.field1, ;
> table2.field2 WITH table1.field2, ;
> table2.field3 WITH table1.field3 ALL;
> FOR table1.field5 = table2.field5 AND ;
> table1.field6 = table2.field6
>
>Cause by default, REPLACE only change the next one!
>
>Hope this help! :)
This is not correct. It uses the FOR scope. You don't need to add ALL clause in the case you have FOR. It doesn't hurt, but it doesn't help either...
At least AFAIK.
If it's not broken, fix it until it is.
My Blog