Subject Re: Opdating ID field
Author svein_erling
Hi Michael!

Why don't you just use a generator and do

UPDATE <table>
SET <newfield> TO gen_id(<generator>, 1)

If you want them to be numbered in a particular order things get more complicated...

HTH,
Set