On 24-07-2011 19:38, Ivan Prenosil wrote: > CREATE TABLE T(I INTEGER); > > EXECUTE BLOCK AS > DECLARE I INTEGER; > BEGIN > INSERT INTO T(I) > SELECT 123 FROM RDB$RELATIONS WHERE RDB$RELATION_NAME='ABC'; > SELECT 123 FROM RDB$RELATIONS WHERE RDB$RELATION_NAME='ABC' INTO :I; > END > > Statement failed, SQLCODE = -204 > Dynamic SQL Error > -SQL error code = -204 > -Ambiguous field name between table RDB$RELATIONS and table RDB$RELATIONS > -RDB$RELATION_NAME > > > (Firebird-3.0.0.29509-0_Win32.7z) > Fixed. Thanks.
Adriano ------------------------------------------------------------------------------ Storage Efficiency Calculator This modeling tool is based on patent-pending intellectual property that has been used successfully in hundreds of IBM storage optimization engage- ments, worldwide. Store less, Store more with what you own, Move data to the right place. Try It Now! http://www.accelacomm.com/jaw/sfnl/114/51427378/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
