Hi,

The help file edb2sql.pdf page 136 mentions:

"The GeneratedWhen column values are as follows:

Always     The generated column is always updated when a row is
inserted or updated, overwriting any value that may exist for
the column"

Now, if you open a table where you have a GENERATED ALWAYS AS IDENTITY field and UPDATE some other field of the record, you would think the generated field is going to be updated as per help file says. However it is not. It is actuall "updated, overwriting" only if you update precisely that column.

Probably the help file is imprecise, with so many SQL guys here, I think it would have been caught by now if it was an error? Anyway, what is the correct behaviour?

regards,
Lucian

errr ... forget about it, I should not be asking anything on Sundays
Lucian