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) ------------------------------------------------------------------------------ Magic Quadrant for Content-Aware Data Loss Prevention Research study explores the data loss prevention market. Includes in-depth analysis on the changes within the DLP market, and the criteria used to evaluate the strengths and weaknesses of these DLP solutions. http://www.accelacomm.com/jaw/sfnl/114/51385063/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
