Hi,
should I be able to edit a joined tables' field via a SP with a
TIBOQuery, TDataSource, and a TDBMemo or TDBRichEdit?

My FB1.5 d/b has...
create table REPORTS
(
PK SMALLINT NOT NULL,
NAME D_VCHAR50,
~snip~
CONSTRAINT PK_REPORTS PRIMARY KEY (PK)
)^

create table REPORT_DETAILS
(
FK SMALLINT,
DEPT D_DEPT,
~snip~
DATE2 DATE,
DESCR D_BLOB1,
CONSTRAINT FK_REPORT_DETAILS FOREIGN KEY (FK) REFERENCES REPORTS
(PK) ON UPDATE CASCADE ON DELETE CASCADE
)^

create or alter procedure UPDATE_REPORTS (OLD_PK SMALLINT, NAME
VARCHAR(50), ~snip~, DATE2 DATE, DESCR BLOB)
as
begin
UPDATE REPORTS SET NAME = :NAME, ~snip~
WHERE PK = :OLD_PK;

update REPORT_DETAILS set ~snip~, DATE2 = :DATE2, DESCR = :DESCR
where FK = :OLD_PK;
end
^
with accesses granted.

My TIBOQuery SQL is
SELECT R.PK
, NAME
~snip~
, D.DATE2
, D.DESCR
FROM REPORTS R
LEFT OUTER JOIN REPORT_DETAILS D on D.FK = R.PK
and D.DEPT = USER

and the Update SQL is
EXECUTE PROCEDURE UPDATE_REPORTS(
:REPORTS.PK,
:REPORTS.NAME,
~snip~
:REPORT_DETAILS.DATE2,
:REPORT_DETAILS.DESCR)

I can see the joined fields' data in the TDBMemo, but cannot edit it!
The TIBOQuery's RequestLive=true & ReadOnly=false.
The TDataset's AutoEdit=true.
The TDBMemo's ReadOnly=false.

Have I missed something, or is this a limitation from using the
TDataset components (so I can try FreeReport)?

Apologies if this is not an IBO issue.
Thank you,
Steve
FB1.5/IBO 4.3Ab_Test