From: Mark R. <ma...@la...> - 2012-01-03 21:25:07
|
I am currently going over the JDBC metadata returned by Jaybird, and I was looking for a way to see if a column is COMPUTER BY / GENERATED ALWAYS AS. I found that I should probably look at RDB$FIELDS.RDB$COMPUTED_BLR or RDB$COMPUTED_SOURCE for this, but I noticed that RDB$RELATION_FIELDS.RDB$UPDATE_FLAG is 0 for a computed column, while it is 1 for 'normal' fields. What is the exact meaning of this field? Is it only 0 for computed columns, or also in other cases (eg views)? Both the Interbase 6 as Helen's book mention it is not used, but apparently it is used (or at least: being set). Mark -- Mark Rotteveel |