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.
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)). In practice, this doesn't seem to be the case
(see
https://stackoverflow.com/ques
On Tue, Jan 3, 2012 at 4:56 PM, Mark Rotteveel 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 not system.domai
On 3-1-2012 22:38, Ann Harrison wrote:
> 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
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 pa
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
> RDB$RELAT
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$U