|Subject||RE: [IBO] IB_Query/SP/KeyLinks|
> SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FIELD3)Another Q
> KeyLinks property set to 'FIELD1'
> and the MasterParamLinks set to 'FIELD3=Mast.FIELD3'
> where "Mast" is the name of the table that has FIELD3 either as
> its primary
> key or as another unique key.
What's the difference (what problems if any would be caused by) using this
in the Query
SELECT FIELD1 FROM SSP(:MYPARAM) WHERE FIELD3='N'
as opposed to adding
in the SQLWhereItems on Prepare SQL?