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
UPDATE RDB$RELATION_FIELDS
SET DEFAULT_BLR='DEFAULT ''N'''
WHERE ...
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.

Hugo.

--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:
> 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
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."