--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 02:48 AM 8/02/2008, Mitch wrote:
> >
> >> >> >Turning off KeyLinksAutodefine or leaving on with the code below
> >still gives the same error.
> >> >> >
> >
> >> >> OK, best describe 1) versions of things (dbserver, client lib,

IBO)

> >> >and 2) at what point you see the exception message.
> >> >>
> >> >
> >> >IBO4.6B, FB2.0, Delphi 2006, FastReport 4.0.
> >> >I get the message when trying to open a report. I have several other
> >> >child-datasets that open successfully for this report, but I am

trying

> >> >to add an additional one and this one wont work.
> >>
> >> You need IBO 4.8 to work with Fb 2.
> >
> >I have just upgraded to IBO 4.8.7 but I'm still having the same

problem.

> Assuming your corrected set is
> SELECT
> ITEM_ATTRIB_DATA
> FROM ITEM_ATTRIB
> WHERE
> ITEM_ID = :ITEM_ID
>
> 1. What is the report doing with the output - is it supposed to be

linked to the other set? e.g. as a detail to a master where the
:ITEM_ID parameter comes from, you would need a set like the following:

>
> SELECT
> pk_column,
> item_id,
> ITEM_ATTRIB_DATA
> FROM ITEM_ATTRIB
> WHERE
> ITEM_ID = :ITEM_ID
>
> 2. What did you put in as your Keylinks?
>
> Helen
>

It seems to have been an issue with the keylinks setting in the
master. I deleted all the keylinks, kept all set to auto, and now
everything seems to work.

Thanks for your help.