|Subject||Re: [IBO] update from one database to another|
> Oh of course, I did not mention, but I was trying to write a routineI just have an UPDATED flag and select the UPDATED=1 records
> 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 !
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
Is this to much of a simplification of what you want to do?
L.S.Caine Electronic Services