Subject | how to use MasterSource as source for parameters of a selectable Stored Procedure |
---|---|
Author | Andeas Hesse |
Post date | 2005-11-23T16:08Z |
How can I use fields from a MasterSource in a TIB_Query as Parameters
for a selectable Stored Procedure.
SelectSQL: select * from PhoneSelect(:idMaster);
where idMaster is the FieldName in the MasterSource dataset.
I have tried MasterLinks, but this only added a where-clause to the query.
I have searched in help files and in source, but did not fnd any solution.
Thanks for help,
Andreas
for a selectable Stored Procedure.
SelectSQL: select * from PhoneSelect(:idMaster);
where idMaster is the FieldName in the MasterSource dataset.
I have tried MasterLinks, but this only added a where-clause to the query.
I have searched in help files and in source, but did not fnd any solution.
Thanks for help,
Andreas