I have code that uses temporary tables in at least 30 places in my programs. This is the way I did complicated queries. Most of these procedures are written 10 years ago (Interbase, Firebird 1.0). I cannot change everything (replace every query that uses temporary tables), cannot do this without proper testing. 

In the first phase I changed every field definiton of these temporary tables, defined my domains 

Integer -> MyIntegerDomain

and changed the definition (DDL) of the temporary tables in my code. 

I sure will change the code / queries that uses those temporary tables. 

Tiberiu