Matthias Hanft wrote:

>> 4. fill the new column using the generator:
>> update MyTable set NewKey=(select gen_id(MyGen,1) from RDB$DATABASE)

update MyTable set NewKey = gen_id(MyGen,1);

> Brilliant :-) (I already wondered how to fill up an "incrementing"
> column automagically.)

Well, now you know of 2 ways to do it ;)

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================