Hi,
the following statement
select R1.RDB$RELATION_NAME
from RDB$RELATION_FIELDS F1
join RDB$RELATIONS R1 on F1.RDB$RELATION_NAME = R1.RDB$RELATION_NAME
where F1.RDB$FIELD_NAME ='EMP_NO' and
(not exists(select R2.RDB$RELATION_NAME
from RDB$RELATION_FIELDS F2
join RDB$RELATIONS R2 on F2.RDB$RELATION_NAME=R1.RDB$RELATION_NAME
where F2.RDB$FIELD_NAME ='PHONE_EXT'));
that was valid in FB 2.5 leads to
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-R1.RDB$RELATION_NAME
-At line 8, column 32
in head.
I'm not sure whether this is a bug or a new restriction according to
some obscure standard.
Frank
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_sfd2d_oct
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
