Subject | Changing domain from Char to Integer |
---|---|
Author | Ed Dressel |
Post date | 2005-06-03T17:38:32Z |
I inadvertantly misdefined a domain as char which was suppose to be
interger. Will the following fix the problem (i.e. am I allowed to
redefine a field with a Char domain an integer domain)?
Thanks
Ed Dressel
Create domain DM_TEMP INteger;
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_TEMP'
where (RDB$FIELD_SOURCE = 'DM_INTEGER')
drop domain DM_INTEGER;
Create domain DM_INTEGER INTEGER default 0;
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_INTEGER'
where (RDB$FIELD_SOURCE = 'DM_TEMP')
Drop domain DM_TEMP;
interger. Will the following fix the problem (i.e. am I allowed to
redefine a field with a Char domain an integer domain)?
Thanks
Ed Dressel
Create domain DM_TEMP INteger;
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_TEMP'
where (RDB$FIELD_SOURCE = 'DM_INTEGER')
drop domain DM_INTEGER;
Create domain DM_INTEGER INTEGER default 0;
update RDB$RELATION_FIELDS set
RDB$FIELD_SOURCE = 'DM_INTEGER'
where (RDB$FIELD_SOURCE = 'DM_TEMP')
Drop domain DM_TEMP;