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

Reply via email to