Subject | RE: [IBO] IB_Query/SP/KeyLinks |
---|---|
Author | Alan McDonald |
Post date | 2004-10-29T11:23:20Z |
> 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.
>
> Helen
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
FIELD3='N'
in the SQLWhereItems on Prepare SQL?