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. []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br MR> On 15-9-2012 1:36, Carlos H. Cantu wrote: >> Hi! >> >> FB 2.5.1 reports error (unkown column) when I try to create a table >> when one of the calculated fields refers another field (in the same >> table) that has a higher creation order. >> >> Is this expected? MR> What do you mean with 'higher creation order'? Do you mean it comes MR> before or after the calculated field in the CREATE TABLE statement? MR> Mark ------------------------------------------------------------------------------ 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
