Hi,

> I think the command it sent to the database was a simple:
>
> ALTER DOMAIN MY_DOMAIN TYPE NUMERIC(15,2);
>
> And it worked.

Hmm, i think this wouldn't change the values in the records.
Only when you read the record the value is converted to NUMERIC(15, 2) which is no problem at that point, BUT the if
there are indexes on those fields the index-entries would stay with the old values unless you update the values (or
recreate the index).

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database developer support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features:
http://www.firebirdsql.org
http://www.firebirdsql.info

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info