Subject Re: Alter Table, add default value to an existing field (2nd post)
Author hugosanfirebird
Thanks Martijn, I would have my suspicion over DEFAULT_BLR field, but
it's a Blob Subtype BLR; how can I assign this kind of datatype?
I can't find anything on the docs about Binary Language
Representation format. It's a public format?
I'm sure
it's not a valid way.
By the way, I need to embed that change on a DDL or DML script (not a
developer tool), because there are many .GDB in production at user's
home that I want to update.
I hope you understand my artificial english.


--- In, "Martijn Tonies" <m.tonies@u...>
> Hi Hugo,
> The only "other" way to do this is directly updating DEFAULT_BLR
> in RDB$RELATION_FIELDS. Good luck.
> With regards,
> Martijn Tonies
> Database Workbench - the developer tool for InterBase & Firebird
> Upscene Productions
> "This is an object-oriented system.
> If we change anything, the users object."