Subject master-detail relation with SP
Author Gediminas
Trying to set master-detail (MD) relation with stored procedures on the
same table (which will be large).
One TIB_Query selects ID, Name & Surname using stored procedure
Select_Short: select * from Select_Short;
the second TIB_Query selects detailed info for the selected row (all
selects via stored procedures work with the same table!) via stored
procedure Select_Detail(:ID), which retrieves Name, Surname, Age, Gender &
other info:
select * from Select_Detail(:ID);

how to set second query to follow master dataset? assigned second's query
mastersource to the first, but how to set ID param?
Using FB 1.5 rc7, IBO 4.2Ie, Builder 6




--/ Gediminas /--
The Truth Is Out There