Subject Re: [IBO] Common Table Expressions
Author Carlos H. Cantu
What happens if you force the keylinks value to some of the retrieved
fields that unique identify a line in the result set?

Carlos H. Cantu
Firebird Performance in Detail - -

SH> Hi,

SH> this is a valid Firebird 2.1 Common Table Expression:

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

SH> union all

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

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

SH> Invalid KeyLinks Entry: DEPT_TREE.RDB$DB_KEY

SH> What can I do?

SH> Best Regards

SH> Stefan Heymann

SH> ------------------------------------

SH> ___________________________________________________________________________
SH> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
SH> without the need for BDE, ODBC or any other layer.
SH> ___________________________________________________________________________
SH> - your IBO community resource for Tech Info papers,
SH> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links