Hi,

this is a valid Firebird 2.1 Common Table Expression:

with recursive
dept_tree as (
select dept_id, name, 0 as lvl
from depts where parent_dept_id is null

union all

select d.dept_id, d.name, h.lvl + 1
from depts d
join dept_tree h
on d.parent_dept_id = h.dept_id
)
select lvl, name, dept_id from dept_tree

In IBO 4.8.7, the IsSelectSql method does not recognize it as a SELECT
statement. And I get an error message:

Invalid KeyLinks Entry: DEPT_TREE.RDB$DB_KEY

What can I do?


Best Regards

Stefan Heymann