Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Question about "GeneratedWhen" column |
Sun, Feb 6 2011 1:49 PM | Permanent Link |
Lucian | 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 |
Sun, Feb 6 2011 1:55 PM | Permanent Link |
Lucian | errr ... forget about it, I should not be asking anything on Sundays
Lucian |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |