Subject Re: [firebird-support] How to fill column with data
Author James
Hi Richard

richard poulin wrote:

> I want to fill a column with unique numbers (let say any unique numbers
> from a series, ie: between 2000 and 9000) . The column already contains
> nulls and integers that will be updated by the new numbers. How could i
> update the whole column with the new values? Thanks
> RP.

I will be using generator for this one. First ill create a generator
like gen_uniquenumber, then execute this statement to fill the update
with the column that has null value this unique numbers.

update tableA
set columnA = gen_id(gen_uniquenumber,1)
where columnA is null;