Subject | Re: [firebird-support] Correct syntax to set field position |
---|---|
Author | Salvatore Besso |
Post date | 2005-04-19T19:45:32Z |
hello Ann and Martin,
thank you for your replies. But at least IBExpert is able to do it, but I
don't know how. Do you mean that it's only an IBExpert internal setting how
the fields order is shown?
Ann:
domains? It would be really nice. Now to change the size of two fields I had
to write a 50+ lines script to drop and recreate all dependent objects :-(
The two domains that I have to change are actually declared as:
SET NAMES ISO8859_1;
.....
CREATE DOMAIN CH_PROVINCE_LONG_NAME
AS VARCHAR(20)
NOT NULL
COLLATE ISO8859_1;
CREATE DOMAIN CH_REGION_NAME
AS VARCHAR(25)
NOT NULL
COLLATE ISO8859_1;
I have to increase both sizes to 30 characters. If it is possible, what
happens with the added space and existing values? Are they padded with
something (i.e. spaces) or do they remain unchanged?
Thanks
Salvatore
thank you for your replies. But at least IBExpert is able to do it, but I
don't know how. Do you mean that it's only an IBExpert internal setting how
the fields order is shown?
Ann:
> Why don't you just change the size of the field directly?The fields are bound to domains. Can I change only the size (VARCHAR) in the
domains? It would be really nice. Now to change the size of two fields I had
to write a 50+ lines script to drop and recreate all dependent objects :-(
The two domains that I have to change are actually declared as:
SET NAMES ISO8859_1;
.....
CREATE DOMAIN CH_PROVINCE_LONG_NAME
AS VARCHAR(20)
NOT NULL
COLLATE ISO8859_1;
CREATE DOMAIN CH_REGION_NAME
AS VARCHAR(25)
NOT NULL
COLLATE ISO8859_1;
I have to increase both sizes to 30 characters. If it is possible, what
happens with the added space and existing values? Are they padded with
something (i.e. spaces) or do they remain unchanged?
Thanks
Salvatore