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 ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel