Dne 23. 11. 2016 v 14:08 Adriano dos Santos Fernandes napsal(a): > On 23/11/2016 10:56, Alexandre Benson Smith wrote: >> create view v as select a from t; > When you use the base field directly, the view field uses the same domain. > > When you create an expression based on this field, the change to it does > not reflect in the view. > > Because Firebird does not recompile dependent objects. > > > Adriano >
Another example - when the table field uses user defined domain, the same domain will be used by view. When I alter the table field by changing it to use another wider domain, the view will retain the original narrow domain. I. ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel