On 15-09-2012 14:02, Carlos H. Cantu wrote: > Example: > > create table a ( > field1 computed by (field2 * 0.5), > field2 numeric (9,2) > ); > > returns: > > Column does not belong to referenced table. > Dynamic SQL Error. > SQL error code = -206. > Column unknown. > FIELD2. > At line 2, column 22. > > BUT > > create table a ( > field2 numeric (9,2), > field1 computed by (field2 * 0.5) > ); > > Works fine. >
Ideally (but DDL and ideally has a great distance) it should work. I consider that all DDL validations should be done as "After this command is executed, will the database state be valid?" Adriano ------------------------------------------------------------------------------ How fast is your code? 3 out of 4 devs don\\\'t know how their code performs in production. Find out how slow your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219672;13503038;z? http://info.appdynamics.com/FreeJavaPerformanceDownload.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
