> Oh of course, I did not mention, but I was trying to write a routine
> to cover various tables so I don't know the field-names unless I
> gather them into a string-list.
>
> Back to the drawing board !

I just have an UPDATED flag and select the UPDATED=1 records
from the source.

Then the source and destination are just
SELECT * FROM TABLE
with the WHERE UPDATE=1 on the source.

Then update source and destination with a SET UPDATE = 0

Works fine and I just replace the TABLE with the name I want
to update.

Is this to much of a simplification of what you want to do?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services