--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> The problem is, it'll be a long job if you have a lot of columns to

update,

> since you need a separate subquery and table alias for each column

you want

> to update. It really would be more efficient to create entirely

new

> records. If you wanted to restore the original PKs, you could just

add a

> column to store it, and use the value to update the PKs on the new

records

> once you'd deleted the old ones.

Thanks again Helen.
This looks like the best approach because I do have a lot of columns
to update.
Before I follow this approach, are there any possibilties using
Cursors? I have continued searching & found something on cursor
statement with for update statement.

Jack