20.07.2021 14:50, Mark Rotteveel пишет:
According to the Firebird Language Reference[1], the
RDB$RELATION_FIELDS.RDB$UPDATE_FLAG signals whether a column is a
computed column (0) or a regular column (1) (or I guess, updatable (1)
vs not-updatable (0)).
Updatable vs non-updatable is correct.
Mark,
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
On 3-1-2012 22:25, Mark Rotteveel wrote:
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).
Ok, I already answered part
On Tue, Jan 3, 2012 at 4:56 PM, Mark Rotteveel m...@lawinegevaar.nl wrote:
The definitive sign of a computed field is RDB$COMPUTED_BLR in either
RDB$FIELDS or RDB$DOMAINS if the field is defined through a domain
There is no RDB$DOMAINS ...
Too many databases... indeed, it's RDB$FIELDS