Subject Re: [firebird-support] change field size painlessly
Author Aage Johansen
On Sat, 10 Jan 2004 03:07:44 +0000 (UTC), James wrote:

> I need to change a field size of a particular field. But Iam getting a
> "Implementation of text subtype 255 not located". I think its because
> of dependencies that causing this error. My problem is if I have to drop
> all the views ,triggers, procedures that could be a lot of work. Is there
> a way to have my field size change without touching those views,
> triggers, and procedures.

What did you do when you got "Implementation of text subtype 255 not
located" ?

Before ALTER (for field lengths) came along, I used to do:
update rdb$fields
set rdb$field_length = 8,
rdb$character_length = 8
where rdb$field_name =
(select rdb$field_source
from rdb$relation_fields
where rdb$relation_name = 'DISTRIB'
and rdb$field_name = 'LENGDE'
where 8 is the new field length (note: it is used twice), DISTRIB is a
table name, LENGDE is a field name.

This used to work, but watch out for multibyte character sets and case
sensitive object names.

Aage J.