Hi Hugo,

> 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?

Not really. It's all internal InterBase/Firebird stuff - some sort of
bytecode that the engine can handle internally to do it's stuff.

> I'm sure
> UPDATE RDB$RELATION_FIELDS
> SET DEFAULT_BLR='DEFAULT ''N'''
> WHERE ...
> it's not a valid way.

Indeed it isn't :)

> 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.

Well, no such luck with a DDL script.


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."