What happens if you force the keylinks value to some of the retrieved
fields that unique identify a line in the result set?

[]s
Carlos H. Cantu
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.FireBase.com.br - www.firebirdnews.org


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, d.name, 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> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
SH> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links