Subject | IB_Query/SP/KeyLinks |
---|---|
Author | Alan McDonald |
Post date | 2004-10-29T08:32:07Z |
I have an IB_Query set with the following SQL
SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FK_SECCODE) WHERE ...
I have the KeyLinks property set to 'FIELD1'
and the MasterParamLinks set to 'FIELD3=FIELD3'
where this field is present in the mastersource datasource dataset.
Now my question is - How does the keylinks record get resolved here if this
one record is being refreshed?
I ask this question because I am now getting a "cursor unknown error" and
I'm pretty sure it's from this query.
Is there some additional setting I should be obeying? What other way can I
set the keylinks property?
thanks
Alan
SELECT FIELD1, FIELD2, FIELD3 FROM LOAN_S_ALL(:FK_SECCODE) WHERE ...
I have the KeyLinks property set to 'FIELD1'
and the MasterParamLinks set to 'FIELD3=FIELD3'
where this field is present in the mastersource datasource dataset.
Now my question is - How does the keylinks record get resolved here if this
one record is being refreshed?
I ask this question because I am now getting a "cursor unknown error" and
I'm pretty sure it's from this query.
Is there some additional setting I should be obeying? What other way can I
set the keylinks property?
thanks
Alan