Master / Detail

[rcoyle]

I am converting a MIDAS 3tier app from BDE to DOA. The program has Master/detail relationships but does not have foreign key constraints defined in the database. When I try to recreate this with DOA components the detail does not return any rows. For that matter the field headers do not show up, but no errors are generated. Below is the stripped down master sql and detail sql statements
THE MASTER
select PROJECTID,
Source,
Sum(Nvl(UnCommitedAmount,0)) UnCommitedAmount
from Account
where Account.ProjectID =:nProjID
Group by Account.ProjectID, Source
Order by source

THE DETAIL
elect
Source,
SourceYear,
Sum(Nvl(UnCommitedAmount,0)) UnCommitedAmount
from Account Acct
where Acct.ProjectID = ROJECTID
and Acct.Source = :SOURCE
Group by Acct.Source, Acct.SourceYear
Order by Acct.source, Acct.SourceYear

The projectid and the source fields are the key fields that link the master to the details and even if I just specify the PROJECTID in the detail nothing shows up. There is truly data there.

 

[rcoyle]

As a further note it seems as though when the master toracledataset opens the detail parameter values are not passed and the detail dataset is not automatically opened