Subject | Re: [IBO] Re: TIBOQuery: Invalid KeyLinks entry: ITEM.RDB$DB_KEY |
---|---|
Author | Helen Borrie |
Post date | 2008-02-07T22:37:25Z |
At 02:48 AM 8/02/2008, Mitch wrote:
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
>Assuming your corrected set is
>> >> >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.
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